Sumifs with multiple criteria

Hello again! Yes, I am working on a Saturday...these formulas are killing me!

I am trying to sum the number of techs that are both "Transactional" and "LM Tech", referencing "Availability" sheet. This is the formula I am using:

=SUMIFS({Availability Range 1}, "transactional", {Availability Range 19}, "GE Tech", {Availability Range 2})

The formula should use the criteria in Range 1 and Range 19 to determine if the cell should be summed. The value in Range 2, should be summed.

Find more posts tagged with

Accepted answers

Stefan

Hi @Amanda Medina ,

SUMIFS works the other way round than SUMIF.

You put the range to be summed first:

=SUMIFS({Availability Range 2}, {Availability Range 1}, "transactional", {Availability Range 19}, "GE Tech")

And you wrote "LM Tech" but in your formula you write "GE Tech"...

Hope this helps

Stefan

All comments

Stefan

Hi @Amanda Medina ,

SUMIFS works the other way round than SUMIF.

You put the range to be summed first:

=SUMIFS({Availability Range 2}, {Availability Range 1}, "transactional", {Availability Range 19}, "GE Tech")

And you wrote "LM Tech" but in your formula you write "GE Tech"...

Hope this helps

Stefan

Amanda Medina

Stefan,

Thank you for your response! I your suggestion worked beautifully! Thank you so much!

Stefan

Happy to help :-)

Stefan

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.