excel _ Count

[fotsal]

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!

[#2 · Accepted solution]

=COUNTIF(A1:A100,"*WordYouAreLookingFor*")

[#3]

thanks! it works perfect