Count only Letters in cells that contain both letters and numbers
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*")
|