COUNTIF in Muti-Select Column

britenour

Good morning, I am trying to count how many times a name appears in a multiselect column, the problem is that when there is more than one name in the column it will not count it. Here's my formula so far

=COUNTIFS({Construction Damage & Complaint Tracker Range 1}, "Gary"

Although Gary's name should count 5 times, it does not because there are other names in that column as well.

Any help would be appreciated!

Mike TV

@britenour

=COUNTIF({Construction Damage & Complaint Tracker Range 1}, HAS(@cell, "Gary"))

However, HAS function needs to find an exact match. So as long as its just Gary and doesn't include a last name that should work.

If it includes a last name you can use:

=COUNTIF({Construction Damage & Complaint Tracker Range 1}, CONTAINS("Gary", @cell))