Referencing multiple contacts within a COUNTIFS formula using OR function

Hi there,

I'm trying to include a list of 9 contacts as part of a COUNTIFS formula, so that if one of these 9 contacts is found in the contact column (multiple contacts enabled), it will be counted as 1 (the rest of the formula is just a status option which works fine already).

I'm looking for something like:

=COUNTIFS({Range 1 - Contacts}, "Person 1 " OR "Person 2" OR "Person 3", {Range 2- Status }, "In Progress")

If you could please offer some help that would be fantastic.

Best wishes,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!