SUMIF with OR function

Jessintha Nathan
Jessintha Nathan ✭✭✭✭

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!