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.