Using COUNTIF with OR
I'm trying to figure out how to add OR to this statement. Below I'm finding the count of Primary, CAS, Archive, and where Course Development is checked. This works fine. I need to find the same thing now but instead of a singular phase as Archive, I need to find phases such as Concept or Agreement, or Prototype.
=COUNTIFS([College/Unit]:[College/Unit], "CAS", Phase:Phase, "Archive", [ID Tier]:[ID Tier], "Primary", [Work Category: Course Development]:[Work Category: Course Development], "1")
Thanks!
Best Answer
-
Try this:
=COUNTIFS([College/Unit]:[College/Unit], @cell="CAS", Phase:Phase, or(@cell="Concept",@cell="Agreement",@cell="Prototype"), [ID Tier]:[ID Tier], @cell="Primary", [Work Category: Course Development]:[Work Category: Course Development], @cell=1)
Answers
-
Try this:
=COUNTIFS([College/Unit]:[College/Unit], @cell="CAS", Phase:Phase, or(@cell="Concept",@cell="Agreement",@cell="Prototype"), [ID Tier]:[ID Tier], @cell="Primary", [Work Category: Course Development]:[Work Category: Course Development], @cell=1)
-
Thank you so much! This worked!
Would you be able to explain to me how using the @cell made the difference here? I tried that before and clearly wasn't using it correctly, but I'm confused about exactly what the expression is doing.
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!