Counif multiple condition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try one of these:

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

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

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif 1
=COUNTIF(range, select items highlighted with specific color) 2
help counting 2
Scrabble Value calculation for Welsh words 0
Help required with COUNTIF/AND function 3
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
counif but not all the cells 2
Counting on 2 criteria 2

Back
Top