Multi-Select Not Counting As Expected for Dashboard

Judith Campf

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.

Paul Newcome

Try this...

=COUNTIFS({Student Satisfaction Survey Range 5}, CONTAINS("More live lessons", @cell))

Paul Newcome

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.

Judith Campf

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.

Paul Newcome

Try this...

=COUNTIFS({Student Satisfaction Survey Range 5}, CONTAINS("More live lessons", @cell))

Judith Campf

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

Paul Newcome

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.