Counif multiple condition

A

Avadivelan TCS

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

Biff

Try one of these:

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

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

Biff
 
Top