COUNTIF pointed at multiple contacts in a cell

I'm trying to count the number of times a name appears in a column that is configured for contacts and is set to allow multiple contacts.

So using the Countif function, I can easily count up the number of times "John Doe" appears in a column...UNLESS....there's a cell that contains "John Doe" and "Jane Doe".

The Countif function doesn't recognize the "John Doe" in a cell if it's accompanied by another name in the same cell.

Any ideas?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!