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

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=37926

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" <(E-Mail Removed)> ¦b¶l¥ó
news:0045152E-8139-4D47-9E92-(E-Mail Removed) ¤¤¼¶¼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" <(E-Mail Removed)> wrote in message
news:0045152E-8139-4D47-9E92-(E-Mail Removed)...
> How do you countif for 2 conditions?
>
> countif ( A1 = "Red" and "B1 = blue")
>
> Bruce