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
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives