Not to worry... I still can follow your formula which works nicely.

All the best to all of you who could help us. You all are amazing!
Thanks a million.

Cheers :)


"francis" wrote in message
...
Hi Sampoerna

I didn't realized that you have posted a 2nd post on the criteria,
this will count the numbers of "was" occurrences in the range

=COUNTIF(A1:A3,"*"&" "&"was"&" "&"*")
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked
An ordinary user helping another ordinary user and learn together

Thank You

cheers, francis



"Sampoerna" wrote:

Thanks francis,

Amazing! I did make a countif formula before. But not works until I saw
this
one. I wish I knew it earlier to use the wildcard "*". I'm so glad to see
this one works. Thanks again.

"francis" wrote in message
...
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.