COUNTIF with multi select dropdown

Julie Hale-Harris

I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit.

In a difference sheet, I'm trying to count the total responses. So Grapes should be counted 4 times, but is only counted twice. If it's not the first option listed, it is not counting. The formula I'm using is =COUNTIF({DOTS 2020 Range 5}, "Apples"). (The DOTS 2020, Range 5 is the other sheet reference). Please advise. I've tried both the "HAS" and "COUNTM" function, but that does not seem to be working (however, I may not be using them correctly).

MCorbin

Try this:

=COUNTIF({DOTS 2020 Range 5}, Contains("Apples",@cell))

MCorbin

Try this:

=COUNTIF({DOTS 2020 Range 5}, Contains("Apples",@cell))

Julie Hale-Harris

It worked! Thank you!

JJ MacIsaac

thank you, this helped me solve a problem I was having, greatly appreciated