Counting number of contacts in a cell, "Allow Multiple Contacts"


Hello. I'm trying to count the number of people (contacts) who appear in cells in a contact list column, where I allow multiple contacts. Using a COUNT function always returns "1", independent of how many contacts are in a given cell.

I'm not looking to return how many times any specific person appears, only to count how many contacts are in a specific cell.

Any ideas? Thanks in advance.

Best Answer