Try one of these:

=COUNTIF(A1:A6,"A")+COUNTIF(A1:A6,"B")

=SUM(COUNTIF(A1:A6,{"A","B"}))

Biff

"Avadivelan TCS" wrote in message
...
Hi,
I want to count all the "A" or "B" in the range.
Ex:
A
C
D
E
B
A
Result : 3.

Thanks in advance for your reply.