SUMIFS + OR ?

Sam Swain

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!

Paul Newcome

Your syntax would be

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

Nick Korna

Hi @Sam Swain,

Change this bit of your formula:

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

To

{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. 👍️