COUNTIF in Muti-Select Column
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!
Best Answer
-
=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))
Answers
-
=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))
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!