Counting Function

[James Burstall]

I am trying to set up a formula than counts the number of
times on one row that there is a cell containing a
particular letter (s) with a blank cell to teh left of it.
I have tried all the help that I can find, but no joy. Is
there anyone out there with any bright ideas?
Thanks

 

[Paul]

I am trying to set up a formula than counts the number of
times on one row that there is a cell containing a
particular letter (s) with a blank cell to teh left of it.
I have tried all the help that I can find, but no joy. Is
there anyone out there with any bright ideas?
Thanks

Amswered in .misc. Please don't multi-post.

 

[Leo Heuser]

One way:

=SUMPRODUCT((LEN(A210)-LEN(SUBSTITUTE(A210," s","")))/2)