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.
Help Article Resources
Check out the Formula Handbook template!