SUMIFS question

CJ Christie

Hi, I'm trying to return a sum based on 2 criteria's.

The state of origin and the type. Not sure how to make it pull the $ or return 0 if its blank.

=SUMIFS({1-Filing Status -State}, =State@row, {1-Filing Status-Type}, ="Form", {1-Filing Status -Fees}, 1, 0))

Thank you!!

Find more posts tagged with

Accepted answers

Scott Orsey

HI @CJ Christie , You're close, but you'll want to review the syntax for SUMIFS(). It's a bit different than the SUMIF() function. Try this:

=SUMIFS({1-Filing Status -Fees}, {1-Filing Status -State}, State@row, {1-Filing Status-Type}, "Form")

Hope this helps. Be well

All comments

Scott Orsey

HI @CJ Christie , You're close, but you'll want to review the syntax for SUMIFS(). It's a bit different than the SUMIF() function. Try this:

=SUMIFS({1-Filing Status -Fees}, {1-Filing Status -State}, State@row, {1-Filing Status-Type}, "Form")

Hope this helps. Be well

DKazatsky2

Hi @CJ Christie,

Give this a try.

=SUMIFS({1-Filing Status -Fees}, {1-Filing Status -State}, State@row, {1-Filing Status-Type}, "Form")

Hope this helps,

Dave

CJ Christie

Success! Thanks for the help!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.