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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!