COUNTIF for mutiple dropdowns in a cell
I am struggling with the proper formula. I have always struggled with the formulas here and Excel.
I have multiple drop downs in a cell, and I need to be able to show, how many times each of these choices were checked.
Using this formula
=COUNTIF([What educational topics were discussed]:[What educational topics were discussed], "Assistance with ADLs")
With each choice having it's own formula, if I only check a single item, I get a count, if I select multiple items I get "0".
Any help is GREATLY appreciated.
Mark
Best Answers

Try something like this: =COUNTIF([What educational topics were discussed]:[What educational topics were discussed], CONTAINS("Assistance with ADLs", @cell))

Thank you. That worked. For my education, why did it work?
Thanks again for the help
Mark
Answers

Try something like this: =COUNTIF([What educational topics were discussed]:[What educational topics were discussed], CONTAINS("Assistance with ADLs", @cell))

Thank you. That worked. For my education, why did it work?
Thanks again for the help
Mark

In your formula you were looking for an exact match of what you have in quotes, so it would only match if that was the only thing selected in the cell. By using the CONTAINS function instead it is searching for the quoted text anywhere within the cell, so regardless of what else is also selected, it will find a match. Make sense?

Thank you very much.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!