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
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!