Forum Discussion
fotsal
Feb 25, 2022Copper Contributor
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 want to count.
Which function i have to use?
thanks!
- =COUNTIF(A1:A100,"*WordYouAreLookingFor*")
2 Replies
- JKPieterseSilver Contributor=COUNTIF(A1:A100,"*WordYouAreLookingFor*")
- fotsalCopper Contributorthanks! it works perfect