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
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 123 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!