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.