Multiple contacts within a COUNTIF formula - please help!

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,


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!