Countif with Multiple arguments for external sheets

ndaudio

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

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.