Multi-Select Not Counting As Expected for Dashboard

Judith Campf
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.

Best Answers