COUNTIF for 2 conditions

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

Guest

How do you countif for 2 conditions?

countif ( A1 = "Red" and "B1 = blue")

Bruce
 
you could use a sumproduct

=SUMPRODUCT(--(A1:A10="red"),--(B1:B10="blue"))

Manges
 
Assume you have following data as a1:b6, fill c1:c6 with 1
Blue Red 1
Red Blue 1
Blue Blue 1
Orange Red 1
Blue Red 1
Red Black 1

in Cell A7 input following formula
=COUNT(IF((A1:A6="blue")*(B1:B6="red"),C11:C16)) and press
"Ctrl"+"Shift"+"Enter" for array calculation
 
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

Excel Need Countifs Formula Help 0
COUNTIF 15
countif where condition should be met 3
Excel function - countif 2
Finding the weighted average of text that have been given values 1
CountIf Condition based on lookup in a list of values 5
Countif Function Using "AND" 3
SUMIF with criteria "<>" & "=" 4

Back
Top