exclude a row from a sum function if value of another cell is "X"
Is it possible to exclude a row from a sum function if a column in that row has a certain value?
I'm trying to build out a cost modeling tool.. and essentially if one row has "cost incurred" vs a blank cell in that particular column, then exclude the cost from the total sum.
=IF([Cost Incurred] = "Cost Incurred", ???
Thanks!
Answers
-
Hey @mtetzlaf
You can include criteria within a SUMIFS function. It does just as it's name says SUM IF......
The syntax is SUMIFS(range that needs to be summed, range1, criteria1, range2, criteria2)
For example
=SUMIFS([cost column]:[cost column], [Cost Incurred]:[Cost Incurred], <>"Cost Incurred")
But if you are needing the IF statement that you started above
IF([Cost Incurred]@row<>"Cost Incurred", insert your sum formula)
Do either of these work for you?
Kelly
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives