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

Find more posts tagged with

Formulas

Accepted answers

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_range2criterion2... ])

Try this:

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

All comments

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_range2criterion2... ])

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.