•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
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#SUM
#SUMIF
#exclude
#negative
#total sum
#values
#column
#sum at the bottom
#cells
#range
#rules
#Excel
#bottom
#data