Multi-Select Not Counting As Expected for Dashboard
I want a count of each time an answer is selected from a multi-select question. The countif is only counting 1 if an answer shows up once, but not counting when an answer appears more than once.
Formula I'm using is: =COUNTIF({Student Satisfaction Survey Range 5}, "More live lessons") to find all the instances of "More live lessons".
The first image is how the results are showing in my data collection. The second image is the actual survey results.
Best Answers
-
Try this...
=COUNTIFS({Student Satisfaction Survey Range 5}, CONTAINS("More live lessons", @cell))
-
Happy to help. 👍️
The parenthesis are color coded to help you track where each statement is opened and closed. This helps when you are nesting a lot of different functions or need to make sure that your argument sets are correct.
The colored parenthesis are there as a helpful tool. Not a warning.
Answers
-
Continuing with my thread, if I use the formula
=COUNTM({Student Satisfaction Survey Range 5}, "More live lessons")
I get the total number of items in that column rather than only the count of "More live lessons".
I want the result to show 3 as the number of times "More live lessons" was selected.
-
Try this...
=COUNTIFS({Student Satisfaction Survey Range 5}, CONTAINS("More live lessons", @cell))
-
That did the trick, @Paul Newcome . Thank you so much.
Have to say that I tried that but saw pink parentheses and thought I was doing something wrong with the formula so I kept removing the pink parentheses, or adding more parentheses, to see if I could get rid of them. Glad to know that they were needed and that it works.
Appreciate the assistance.
Judy
-
Happy to help. 👍️
The parenthesis are color coded to help you track where each statement is opened and closed. This helps when you are nesting a lot of different functions or need to make sure that your argument sets are correct.
The colored parenthesis are there as a helpful tool. Not a warning.
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