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." <JIMH@discussions.microsoft.com> wrote in message
news:55B4B548-DC7A-432D-89A2-6F976E3225DE@microsoft.com...
> 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 <at>yahoo<dot>com
----