Counting Cells with Multiple Values

New Contributor



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)



You can try COUNTIF like in this example.



Thank you! It totally works!