Thanks Ron,

Glad to have you with us. I can see how usefull when we could expand the
word search possibilities.
Yes! very helpfull and formula works as needed.


"Ron Coderre" wrote in message
...
This regular formula counts cells that:
. Contain only "was"
. Start with the word "was"
. End with the word "was"
. Contain "was"
Excluding "was" as part of a word...eg "wasn't"

=SUM(COUNTIF(A1:A3,{"was","was *","* was","* was *"}))

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)


"Sampoerna" wrote in message
...
Oppss.. Sorry,

There is missing word. And the target Word should be " was "
corresponding to previously given example

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