Using COUNTIF with OR

jessicawstage

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!

Leibel S

@jessicawstage

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)

Leibel S

@jessicawstage

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)

jessicawstage

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!