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