SOLVED

Counting Cells with Multiple Values

New Contributor

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 Replies
best response confirmed by Peter Bartholomew (Trusted Contributor)
Solution

@JJinMT 

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

You can try COUNTIF like in this example.

countif.JPG 

@Quadruple_Pawn 

Thank you! It totally works!