Sheet Summary counting a name in a contact list column

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!

Find more posts tagged with

Accepted answers

ker9

@k_duffie5570

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

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.