COUNTIF question - counting cells which contain a specific letter...

Aitch

Board Regular
Is there a way to use the COUNTIF function to count cells if they contain a single letter - for example below, when a cell has the letter A, the count would be 3 in the top row

3
12345
A4567
3546
23A78
765
2A6A8

<tbody>
</tbody>

I thought it would be easy using wildcards, but is doesn't seem to work... and I think having two letters in the cell makes things worse!

Thanks for helping!
 
Last edited:

Aitch

Board Regular
I tried that - but forgot the "" lol... thank you!

Is there a way to count cells which contain a number of different letters, or even any kind of alphabetical character?
 

JoeMo

MrExcel MVP
I tried that - but forgot the "" lol... thank you!

Is there a way to count cells which contain a number of different letters, or even any kind of alphabetical character?
You are welcome - thanks for the reply. Can you be a bit more descriptive on your new question and maybe provide a few examples of what you want to do?
 

Aitch

Board Regular
Yup!

5
123456
12A34B
1CC345
1ABCD5
111222
ABCDEF
123123
123EF6

<tbody>
</tbody>


So in the column, there are 5 cells which contain letters - is there a way to use COUNTIF to find this value?
 

XOR LX

Well-known Member
Assuming all of the cells are not formatted as Text...

=COUNTA(A2:A9)-COUNT(A2:A9)
If your assumption is correct then we can also use:

=COUNTIF(A2:A9,"?*")

though note that your count will also include any null strings ("") within the range, should there be any.

Regards
 

Some videos you may like

This Week's Hot Topics

Top