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