How to sum a column but exclude percentages that are in the same column

[jennlynn]

How can I SUM a column when there are dollar amounts and percentages in the same column. I want to sum the amount but exclude the cells that are percentages?

 

[dreid1011]

Are there any dollar amounts less than $1.01 and any percentages greater than 100?

 

[Joe4]

Welcome to the Board!

Are all the percentages between 0% and 100%, and all the dollar amounts greater than 1?
If so, then you should be able to use a SUMIF (or SUMIFS) formula to only include values above/below a certain value (1).

Or, is there any other associated column that can be used to helped distinguish the two (once again, we can use SUMIF or SUMIFS functions).

Perhaps it would be helpful to show us some sample data.