COUNTIFS and OR criteria
Hello,
I am trying to create a formula to pull from two different columns where one has multiple "or" scenarios. For example, I need a count of rows that = "Not Started" and is either = "BD, Bid Mgmt, CRO, Customer, Product, Sales, or Other". Below is what I've been trying and it's not working. Appreciate the help!
=COUNTIFS({Advocacy Placement Tracker Range 1}, "Not Started", {Advocacy Placement Tracker Range 3}, "BD", OR {Advocacy Placement Tracker Range 3}, "Bid Mgmt", OR {Advocacy Placement Tracker Range 3}, "CRO", OR {Advocacy Placement Tracker Range 3}, "Customer", OR {Advocacy Placement Tracker Range 3}, "Product", OR {Advocacy Placement Tracker Range 3}, "Sales", OR {Advocacy Placement Tracker Range 3}, "Other")
Best Answer
-
Hi Adah,
Try this:
=COUNTIFS({Advocacy Placement Tracker Range 1}, "Not Started", {Advocacy Placement Tracker Range 3}, AND(OR(@cell="BD", @cell="Bid Mgmt", @cell="CRO", @cell="Customer", @cell="Product", @cell="Sales", @cell="Other")))
-Aya
Answers
-
Hi Adah,
Try this:
=COUNTIFS({Advocacy Placement Tracker Range 1}, "Not Started", {Advocacy Placement Tracker Range 3}, AND(OR(@cell="BD", @cell="Bid Mgmt", @cell="CRO", @cell="Customer", @cell="Product", @cell="Sales", @cell="Other")))
-Aya
-
Thank you, Aya. This works! Appreciate the quick response.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!