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...
- Feb 25, 2022=COUNTIF(A1:A100,"*WordYouAreLookingFor*")
JKPieterse
Feb 25, 2022Silver Contributor
=COUNTIF(A1:A100,"*WordYouAreLookingFor*")
- fotsalFeb 25, 2022Copper Contributorthanks! it works perfect