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
Check out the Formula Handbook template!