Count letters

J

JIM.H.

Hello,

In the range of A1-K1, I have letters A, B, C, D, F in the cells and I need
to count how many A, and B, and C, … are available?
How can I do this?
Thanks
 
J

JIM.H.

Thanks for reply. I actually need to count A, A-, B, B-, I seems when it
counts A, it includes A- too. How can I avoid it?
 
R

Ragdyer

Are you sure?

That Countif formula *should not* count "A-" as an "A".

How are the letters being entered into the cells?
Are they being keyed in, or are they the returns of a formula?

Is there *only* one letter in a cell?
 
M

Max

=COUNTIF(A1:K1,"A")

As is, JMB's suggested formula works ok for me.
It doesn't pick up the "A-", only the "A".
Perhaps try it again?
 
Top