Sum Multiple Criteria

I'm looking to sum the total in the CS Error Cost column anytime the Responsibility column equals CSC, ISG or UAL. I've attempted different nesting versions of the SUMIF and SUMIFS but keep getting an error. Below is one example of what I attempted.

=SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility, "CSC", +SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility, "ISG", +SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility, "UAL")

Find more posts tagged with

Accepted answers

VBAGuru

Ok, I think see the issue, you are using just the standard Sumif. I didn't see that initially when I focused in on the ). Use Sumifs instead. Minor change, but I think that is what you are looking for.

VBAGuru

@Tonya Briere See above

All comments

VBAGuru

Main thing are your )'s as you are not closing out your individual Sumif's. Try:

=SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility, "CSC") +SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility, "ISG") +SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility, "UAL")

Tonya Briere

Unfortunately that did not work. I'm receiving a #INCORRECT ARGUMENT SET error. I added a comma prior to each + but then I received a #UNPARSEABLE error.

VBAGuru

@Tonya Briere See above

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.