Formula

Bruce Case

Hi Community. I have what I believe is a simple formula question, but I have honestly just about everything. In short, I have a Sheet with an Assigned To Contact List column where they value may be a single person, or multiple names. I am trying to count the number of times per individual. Such as, I many time within the Sheet and the Assigned To column is Billy Bob, Susan Smith, etc.

Gia Thinh

The + "" will convert the cell value to a string that's eligible for a comparison of the CONTAINS function.

Happy to help.

Gia Thinh

Hi @Bruce Case

Please try using the following formula. In it, I want to count the number of times the name "Gia Thinh Co." appears in the Assigned To column. The expected result is 4.

=COUNTIFS([Assigned To]:[Assigned To], CONTAINS("GIA THINH Co.", @cell + ""))

Hope it works for you.

Bruce Case

Thank you! That worked. I was missing the + "" after the @cell at the end.

Gia Thinh

The + "" will convert the cell value to a string that's eligible for a comparison of the CONTAINS function.

Happy to help.