Forum Discussion

fotsal's avatar
fotsal
Copper Contributor
Feb 25, 2022
Solved

excel _ Count

Hi, i have a column in excel where it contains text data and i want to count a specific word in how many cells is appeared. To clarify that the cells contain sentences and not just the single word i...
  • JKPieterse's avatar
    Feb 25, 2022
    =COUNTIF(A1:A100,"*WordYouAreLookingFor*")

Resources