How do you countif for 2 conditions? countif ( A1 = "Red" and "B1 = blue") Bruce
B Bruce Jun 15, 2005 #1 How do you countif for 2 conditions? countif ( A1 = "Red" and "B1 = blue") Bruce
M mangesh_yadav Jun 15, 2005 #2 you could use a sumproduct =SUMPRODUCT(--(A1:A10="red"),--(B1:B10="blue")) Manges
A abc Jun 15, 2005 #3 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
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
