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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!