# 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

• ✭✭✭✭✭✭
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.

• ✭✭✭✭✭✭
Answer ✓

Your syntax would be

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

• Thanks Paul, that worked!

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!