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
Check out the Formula Handbook template!