Sheet Summary counting a name in a contact list column

k_duffie5570

Hello

I have a relatively simple request. I am trying to count the number of times a name is in a column for a Sheet Summary. The Column Type I am referencing is a contact list. I need it to count the name regardless of how many other names might be in the cell. I keep getting 0 as my result even though the name appears multiple times. My formula is:

=COUNTIF(Brokers:Brokers, CONTAINS(@cell,"Bill Jones"))

I have also tried the above formula using HAS instead of CONTAINS. What am I missing? Does my column properties setup have anything to do with it? Any help would be greatly appreciated!

ker9

@k_duffie5570

This works for me if Brokers is a contact type column with multi-select.

=COUNTIF(Brokers:Brokers, HAS(@cell, "Bill Jones"))

Jason P

Hi @k_duffie5570

Try =COUNTIF([Brokers]:[Brokers], "Bill Jones")

k_duffie5570

Thanks for trying to help, but that did not work. Still getting 0 and it took the brackets out of the formula when I hit enter.

ker9

@k_duffie5570

This works for me if Brokers is a contact type column with multi-select.

=COUNTIF(Brokers:Brokers, HAS(@cell, "Bill Jones"))

k_duffie5570

Thank you @ker9 ! That worked! Must have had a missed syntax when I tried before.