Countif on column with multiple answers

So I am creating a dashboard to calculate how many times a certain answer is given for a question on a form. On the form, they can answer things like teamwork, culture, quality, recruitment, communication, etc. but they can also select more than one answer in this column, and I think that is throwing my formula off.
I used initially =countif (positive highlights, "teamwork") and got a 0, where it should be a 1. The only answer right now is teamwork but they also selected culture, quality and recruitment so I think that is messing my answer up. What formula can I use for this?
Best Answer
-
Okay try it this way:
=COUNTIF({Positive Highlights}, FIND("Teamwork", @cell) >0
I edited this back to FIND function.
Answers
-
You can use a formula like this that will count in a multi select column:
=COUNTIF(Answer:Answer, FIND("Teamwork", @cell) >= 1)
Need to adjust the "Answer" to either your column or your range or cross sheet reference.
-
That is saying unparsable when I try that.
-
Can you post your formula?
-
I have tried this as well and get a 0 here too where it should be 1:=COUNTIF({Positive Highlights}, CONTAINS("Teamwork", {Positive Highlights}))
I tried with yours: =COUNTIF({Positive Highlights}:{Positive Highlights}, FIND("Teamwork", {Positive Highlights}) > =1)
-
Okay try it this way:
=COUNTIF({Positive Highlights}, FIND("Teamwork", @cell) >0
I edited this back to FIND function.
-
This worked! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!