I am trying to use COUNTIF to count a certain word (from a multi-select dropdown) in a column

A. Wilk

The formula I tried to use isn't working to read what I need it to...

Using =COUNTIF({Q1 - Strengths}, "Accountability") hasn't done it correctly.

I used =COUNTM({Q1 - Strengths}, "Accountability") but it counts everything in column, not only the word/title I need it to.

Nic Larsen

Try: =COUNTIF({Q1 - Strengths}, FIND("Accountability", @cell) >= 1)

Jason Tarpinian

I would suggest using the HAS function for this. Nic's solution will work, but will find any string of text within the cell that says "Accountability". So if there is another strength labeled "Poor Accountability" (what a strength!) the FIND would also count that. The HAS function looks specifically for a string as it exists in the dropdown selections.

=COUNTIFS([Q1 - Strengths]:[Q1 - Strengths], HAS(@cell, "Accountability"))

A. Wilk

Worth a mention that I'm trying to pull the info from a separate sheet.

topazfae

you have to use HAS. I got it to work - try this -

=COUNTIFS([Q1-Strengths]:[Q1-Strengths], HAS(@cell,"Accountability")) (this is if you have named your range. If you name your range, use {named range}

A. Wilk

Thank you! The suggestions helped me get it to work and pull the right information!