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

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

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

It worked! Thank you!

thank you, this helped me solve a problem I was having, greatly appreciated
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!