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!
Best Answer
-
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.
Answers
-
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!!
-
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 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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!