COUNTIF with keywords

Evgeniya Nazarnaya · 09/26/22

Hello,

I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. "communication"). The cell itself won't be only composed of that word, but will just contain it.

My formula so far is =COUNTIF([Job Classification]:[Job Classification], CONTAINS("communication", [Job Classification]:[Job Classification]))

So far it is currently not working - the message I get is a count of "0".

Thank you

Darren Mullen · 09/26/22

@Evgeniya Nazarnaya Hi! Since you are already referencing the range "Job Classification" in your COUNTIF, you need to change your CONTAINS function to CONTAINS("communication", @cell) .

See my video on the @cell operator, if you'd like to learn a little more. https://youtu.be/KchiWBgsv4A

Darren Mullen · 09/26/22

@Evgeniya Nazarnaya Hi! Since you are already referencing the range "Job Classification" in your COUNTIF, you need to change your CONTAINS function to CONTAINS("communication", @cell) .

See my video on the @cell operator, if you'd like to learn a little more. https://youtu.be/KchiWBgsv4A

Evgeniya Nazarnaya · 09/26/22

Hey Darren,

Thank you for your help! That's exactly what I had needed, and thank you for the explanation

Cheers,

Evgeniya

Formulas and Functions

Formulas and Functions

COUNTIF with keywords

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula - use % complete to determine whether in progress

Formula error

TRYING TO FIND THE ERROR IN THIS FORMULA