Formula Assistance Needed

Amy Shank

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".

Jake Gustafson

I think you need to use SUMIFS instead of the singular SUMIF.

=SUMIF( range criterion [ sum_range ])

=SUMIFS( range criterion_range1 criterion1 [ criterion_range2​criterion2​... ])

Try this:

=SUMIFs([Payment Amount]:[Payment Amount], [Payment Method]:[Payment Method], "", Territory:Territory, <>"International")

Jake Gustafson

I think you need to use SUMIFS instead of the singular SUMIF.

=SUMIF( range criterion [ sum_range ])

=SUMIFS( range criterion_range1 criterion1 [ criterion_range2​criterion2​... ])

Try this:

=SUMIFs([Payment Amount]:[Payment Amount], [Payment Method]:[Payment Method], "", Territory:Territory, <>"International")

Amy Shank

That is exactly what I needed! Thank you so very much!

Jake Gustafson

You are welcome. Happy Friday, have a great weekend, relax now that you've ironed out your troublesome formula.