COUNTIF with multi select dropdown

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).

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!