Assume that you want to count how many times washing appear in the range
try
=COUNTIF(A1:A3,"*"&"washing"&"*")

This is not case sensitive so its counts both A2 and A3


--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis



"Sampoerna" wrote:

Hi,
I want to count how many cells are they that have a specific word. e.g.
A1= He was watching
A2= She was washing
A3= Washing is fun

which is equal to 2

Thanks in advance for any help.