Counting Cells with Multiple Values

[JJinMT]

Hello,

I have individual cells in the same column filled with multiple keywords - each separated by a semicolon (i.e., achievement; obstacles; reasoning; determination). There seem to be many count functions yet the one I am familiar with is COUNTIF - but, in this case, it only works if the cell contains just the one keyword I am looking for. Is there a better COUNT option that will single out just the keyword I am looking for amongst other keywords in the same cell? Thanks in advance!

[#2 · Accepted solution]

@JJinMT 

=COUNTIF($A$1:$A$7,"*"&C1&"*")

You can try COUNTIF like in this example.

 

[#3]

@OliverScheurich 

Thank you! It totally works!