Count only Letters in cells that contain both letters and numbers

T

TommyB

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!
 
S

smartin

TommyB said:
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!
Click to expand...

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
WORD VBA Search and switch to advanced ... 1
Removing letters from cells 2
Count in a range of numbers 9
Excel - Ignoring the contents of cells when there are letters in thecell 3
How to ignore the in between cells? 0
add multiple letters to the end of multiple cells 1
Count the letters in the cells and sum in another cell 1

Top