Counting occurrences of values in a multi-select dropdown list

I have looked through all of the answers for this topic, and still cannot find a solution that works for me. I have a sheet with a multi-select dropdown used to code responses. In another sheet, I want to count the number of times a certain value appears in any dropdown in the sheet column. Here is my formula:
=COUNTIFS({All Action Items Coding}, CONTAINS("Accountability", @cell))
{All Action Items Coding} is a column range in another sheet that contains the dropdown answers. I want to see if any cell in {All Action Items Coding} contains the string "Accountability". I have created the function based on answers to similar previous questions, but I get "#CONTACT EXPECTED" as an error.
Still don't understand what I am doing wrongβ¦
Thanks so much,
Emily
Best Answer
-
@emilyc9 I tested this on my end and your formula is ALMOST correct. Your "=countifs( " should just be a "countif("β¦ no "s". You're only doing one if which is the contains.
Also if your getting a "#Contact Expected" error, it's because the column type where your formula is at is set to a contact column which cannot calculate a non contact value. Because it's a contact column it's literally expecting contact⦠not a count.
Matt Lynn
How can I help? Schedule some time on my calendar: CLICK HERE
Answers
-
@emilyc9 I tested this on my end and your formula is ALMOST correct. Your "=countifs( " should just be a "countif("β¦ no "s". You're only doing one if which is the contains.
Also if your getting a "#Contact Expected" error, it's because the column type where your formula is at is set to a contact column which cannot calculate a non contact value. Because it's a contact column it's literally expecting contact⦠not a count.
Matt Lynn
How can I help? Schedule some time on my calendar: CLICK HERE
-
Thank you immensely. This was the answer. I did have the cell type set to "Contact List"!!!!
Really appreciate it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!