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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives