Count letters
 

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

=COUNTIF(A1:K1,"A")

"JIM.H." wrote:

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

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?

"JMB" wrote:

=COUNTIF(A1:K1,"A")

"JIM.H." wrote:

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

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?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JIM.H." wrote in message
...
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?

"JMB" wrote:

=COUNTIF(A1:K1,"A")

"JIM.H." wrote:

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

=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?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----