SUMIF with OR function

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!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful". This lets others searching for a similar solution know that one may be found here.

Paul Newcome

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?

Jessintha Nathan

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.

Paul Newcome

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"))

Jessintha Nathan

Paul this works perfectly, thank you!!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful". This lets others searching for a similar solution know that one may be found here.

Jessintha Nathan

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

Paul Newcome

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