How do you countif for 2 conditions?

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

Bruce

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



"Bruce" ¦b¶l¥ó
¤¤¼¶¼g...
How do you countif for 2 conditions?

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

Bruce

=SUMPRODUCT(--(A2:A100="Red"),--(B2:B100="Blue"))

--
HTH

Bob Phillips

"Bruce" wrote in message
...
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"))

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379268

put "red"/"blue" in a cell (eg A1)
=countif(a2:a20,a1)

"Bruce" ...
How do you countif for 2 conditions?

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

Bruce