You Rock...that was so simple.
Thanks a million
--
TommyB


"smartin" wrote:

TommyB wrote:
Hello to all.

I have a Column that has cells with both numbers and letters, like this:
W 6-2
L 3-7
W 11-6
W 1-0

I want to add up the number of W's that appear in this range. Don't seem to
be able to figure it out. Can anyone help?
Thanks!


Assuming you only want to count a cell once when it contains at least
one "W", try this:

=COUNTIF(A1:A4,"*W*")