SUMIFS + OR ?

Hello community, I am trying to use a SUMIFS formula with part of the formula using the OR function.

=SUMIFS({Loads}, {A/B}, "A", {Rack#}, ">100", {Rack#}, "<199", {Outlets}, "L1A", {Outlets}, "L1B", {Outlets}, "L1C")

The first part of the formula I have put in bold works well. I am trying to make the second part (with the three "{Outlets}" references) to 'SUM' if the cell reads either "L1A" or "L1B" or "L1C"

The current formula will only sum if the cell contains all three values.

Any help much appreciated.

Thank you in advance!

Find more posts tagged with

Accepted answers

Paul Newcome

Your syntax would be

=SUMIFS(......................................, {Range}, OR(@cell = "This", @cell = "That", @cell = "Something else"))

All comments

Nick Korna

Hi @Sam Swain,

Change this bit of your formula:

{Outlets}, "L1A", {Outlets}, "L1B", {Outlets}, "L1C"

{Outlets}, OR(@cell = "L1A", @cell ="L1B", @cell = "L1C")

To get:

=SUMIFS({Loads}, {A/B}, "A", {Rack#}, ">100", {Rack#}, "<199", {Outlets}, OR(@cell = "L1A", @cell ="L1B", @cell = "L1C"))

If the first part of your formula was already working, this should do the last little bit for you.

Paul Newcome

Your syntax would be

=SUMIFS(......................................, {Range}, OR(@cell = "This", @cell = "That", @cell = "Something else"))

Sam Swain

Thanks Paul, that worked!

Paul Newcome

Happy to 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.