Forum Discussion

JJinMT's avatar
JJinMT
Copper Contributor
Jul 03, 2022
Solved

Counting Cells with Multiple Values

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!

Resources