Counif multiple condition
Thanks. Its working.
"Biff" wrote:
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.
|