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

  • Jake Gustafson
    Jake Gustafson ✭✭✭✭✭✭
    Answer ✓

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!