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

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @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)

Answers

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓

    @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)

  • 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!