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!
Best Answer

Your syntax would be
=SUMIFS(......................................, {Range}, OR(@cell = "This", @cell = "That", @cell = "Something else"))
Answers

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.

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

Thanks Paul, that worked!

Help Article Resources
Categories
Check out the Formula Handbook template!