Countif on column with multiple answers

tmichelle068

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?

Nic Larsen

Okay try it this way:

=COUNTIF({Positive Highlights}, FIND("Teamwork", @cell) >0

I edited this back to FIND function.

Nic Larsen

@tmichelle068

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.

tmichelle068

That is saying unparsable when I try that.

Nic Larsen

Can you post your formula?

tmichelle068

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)

Nic Larsen

Okay try it this way:

=COUNTIF({Positive Highlights}, FIND("Teamwork", @cell) >0

I edited this back to FIND function.

tmichelle068

This worked! Thank you so much!