Countif with Multiple arguments for external sheets


I am looking to count the total number of specific persons within a smartsheet using COUNTIF. I have a working function for one person, but I need to integrate multiple persons. This formula references a seperate sheet so my code is a little long. How can I make this work for me?

This works

=COUNTIF({external sheet name}, "Person 1")

Ideally I'd like to do something like this:

=COUNTIF({external sheet name}, "Person 1", "Person 2", "Person 3")


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @ndaudio,

    If you want the total amount of times Person 1, 2 & 3 appear then you can use a simple addition:

    =COUNTIF({external sheet name}, "Person 1") + COUNTIF({external sheet name}, "Person 2) + COUNTIF({external sheet name}, "Person 3")

    Or you can use an OR statement in combination with @cell:

    = COUNTIF({external sheet name}, (OR(@cell = "Person 1", @cell = "Person 2", @cell= "Person 3")))

    Both of these should give you the result you're after so pick whichever one you prefer.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!