How to Use SUMIF Function for Sheet Summary
Hello! I am trying to use smartsheet to support budget tracking. I'd like to summarize the amount spent and section by our spend category. So if my Cost Center Category is equal to "Paid Media" I would like a sum of all rows meeting this criteria.
So my range headings are Cost Center Category and Amount, my Criterion is that Cost Center Category="Paid Media"
Thanks all in advance for your help-- I've tried copying and pasting some other's formulas and have not been successful.
Answers
-
Sarah,
Post your formula as is, and I can take a look. That's a pretty simple sum. Likely you can use a has() or Contains() with the @cell operator in your criterion.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Hello and thank you for your help! I've come back to this and realized I need to use SUMIFS to separate by brand. Here is what I have that is not returning a valid answer
=SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], "Misc Advertising", Brand:Brand, "Gemini Signage - US")
-
@sarahjuntunen You say it isn't returning a "valid answer". Does that mean the sum is wrong, or it is returning an error?
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen I was mistaken-- the formula is working as posted. Thanks for looking into this with me!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!