SUMIFS formula with multiple criteria help

AlexisJ

I have a formula that works but once I add additional criteria it breaks.

=SUMIFS({Registration Cost}, {Requestor Email}, "jdoe@company.gov") - This formula works.

Now I need to sum the cost if it is assigned to a specific person AND the Wish List box is checked.

=SUM({Cost}, {Requestor Email}, "jdoe@company.gov", AND(OR({Wish List}, 1))))

It is coming back as #unparseable

Find more posts tagged with

Accepted answers

JamesB

@AlexisJ This is still a SUMIFS. The formula written below is if the reference information is in the same sheet.

=SUMIFS(Cost:Cost, [Requestor Email]:[Requestor Email], "jdoe@company.gov", [Wish List]:[Wish List], 1)

IF The Requestor Email is not jdoe@company.gov or Wish List is not Checked, then the SUMIFS formula is false and will not perform the calculation.

All comments

JamesB

@AlexisJ This is still a SUMIFS. The formula written below is if the reference information is in the same sheet.

=SUMIFS(Cost:Cost, [Requestor Email]:[Requestor Email], "jdoe@company.gov", [Wish List]:[Wish List], 1)

IF The Requestor Email is not jdoe@company.gov or Wish List is not Checked, then the SUMIFS formula is false and will not perform the calculation.

AlexisJ

@JamesB It worked! Thank you.

JamesB

Your Welcome

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.