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 cou...
  • OliverScheurich's avatar
    Jul 03, 2022

    JJinMT 

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

    You can try COUNTIF like in this example.

     

Resources