Formula Assistance Needed
Wondering if you could help me with another formula in Smartsheet.
What seems off about this one?
=SUMIF([Payment Method]:[Payment Method], "", [Payment Amount]:[Payment Amount]),(Territory:Territory),(NOT("International"))
I want to sum the "Payment Amount" column IF the "Payment Method" column is blank and IF the "Territory" column DOES NOT contain "International".
Best Answer
-
I think you need to use SUMIFS instead of the singular SUMIF.
=SUMIF( range criterion [ sum_range ])
=SUMIFS( range criterion_range1 criterion1 [ criterion_range2criterion2... ])
Try this:
=SUMIFs([Payment Amount]:[Payment Amount], [Payment Method]:[Payment Method], "", Territory:Territory, <>"International")
Answers
-
I think you need to use SUMIFS instead of the singular SUMIF.
=SUMIF( range criterion [ sum_range ])
=SUMIFS( range criterion_range1 criterion1 [ criterion_range2criterion2... ])
Try this:
=SUMIFs([Payment Amount]:[Payment Amount], [Payment Method]:[Payment Method], "", Territory:Territory, <>"International")
-
That is exactly what I needed! Thank you so very much!
-
You are welcome. Happy Friday, have a great weekend, relax now that you've ironed out your troublesome formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!