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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!