# SUMIF with OR function

✭✭✭✭

Hello!

=COUNTIFS({Weekly Shop Visit Update Range 10}, >=[Start Date]17, {Weekly Shop Visit Update Range 10}, <=[End Date]17, {Weekly Shop Visit Update Range 7}, "M56-B", {Weekly Shop Visit Update Range 8}, [Column30]\$2, {Weekly Shop Visit Update Range 88}, "HEAVY/PRSV/LLP")

How do I create options where {Weekly Shop Visit Update Range 88}, "HEAVY") returns value if one of three matches "MEDIUM" and "LIGHT"

Thank you!

• ✭✭✭✭✭✭

I'm not sure I follow. Are you trying to SUMIFS or COUNTIFS? Are you looking for rows where Range 88 is "HEAVY" or "MEDIUM" or "LIGHT", or cells that contain one of those words within additional text?

• ✭✭✭✭

Hello Paul!

Yes I'm looking for options to select if cell contains one either "HEAVY", "MEDIUM" or "LIGHT" for both SUMIF and COUNTIF functions.

Thank you for the helping out.

• ✭✭✭✭✭✭

Try something like this...

=COUNTIFS({Weekly Shop Visit Update Range 10}, >=[Start Date]17, {Weekly Shop Visit Update Range 10}, <=[End Date]17, {Weekly Shop Visit Update Range 7}, "M56-B", {Weekly Shop Visit Update Range 8}, [Column30]\$2, {Weekly Shop Visit Update Range 88}, OR(@cell = "HEAVY", @cell = "MEDIUM", @cell = "LIGHT"))

• ✭✭✭✭

Paul this works perfectly, thank you!!

• ✭✭✭✭

Paul can I use the OR statement in a SUMIF function in the same manner?

• ✭✭✭✭✭✭

Yes. It would be exactly the same where you enter "range comma criteria" and your OR statement is your criteria.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!