-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to sum a column but exclude percentages that are in the same column
- Thread starter jennlynn
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,300
- Office Version
- 365
- Platform
- Windows
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.
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.
Upvote
0
Similar threads
- Question
