Countif when multiple values
I have a form that allows users to multi select.
I have a metrics sheet that counts the number of times a selection appears, however, it's only working for those that only had a single value selected. Multi-select are NOT being counted.
Is there a way to get counts when there are multiple values in the same cell?
Here's the formula I'm using right now.
=COUNTIF({Request Tracker Range 4 - Request Type}, Category9)
Best Answer
-
@TraisHorloff
The order of the function calls matter. In this cause you want.=COUNTIF({Request Tracker Range 4 - Request Type}, OR(HAS(@cell, "Category9"), HAS(@cell, Category10")))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
=COUNTIF({Request Tracker Range 4 - Request Type}, HAS(@cell,Category9))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thanks @Mark.poole I will give it a shot!
-
How would the formula look like if the cells I'm counting have multiple values. This one doesn't seem to be working as it always show 0. Thanks for your help.
=COUNTIF({Request Tracker Range 4 - Request Type},HAS(@cell,OR(@cell="Category9",@cell="Category10")))
-
To clarify, I want to count the items, which have "Category9" or "Category10". The cells have multiple values "Category1" to "Category10".
-
@TraisHorloff
The order of the function calls matter. In this cause you want.=COUNTIF({Request Tracker Range 4 - Request Type}, OR(HAS(@cell, "Category9"), HAS(@cell, Category10")))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
That's it, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
