•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Creating rules for a SUM
So I have all these values in a column, but if any cells in this range goes negative, I want it excluded from the sum at the bottom.
Is there a way to do a SUMIF for any cell that might go negative to exclude it from the total sum?
Basically it would look like this
100
200
250
100
SUM: 650 OR..
100
-100
200
250
200
SUM: 750
[link] [comments]
Want to read more?
Check out the full article on the original site