COUNTIF for 2 conditions

[Bruce]

How do you countif for 2 conditions?

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

Bruce

[mangesh_yadav]

you could use a sumproduct

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

Mangesh

[abc]

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" <Bruce@discussions.microsoft.com> 在郵件
news:0045152E-8139-4D47-9E92-5F982F48D047@microsoft.com 中撰寫...
> How do you countif for 2 conditions?
>
> countif ( A1 = "Red" and "B1 = blue")
>
> Bruce

[Bob Phillips]

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

--
HTH

Bob Phillips

"Bruce" <Bruce@discussions.microsoft.com> wrote in message
news:0045152E-8139-4D47-9E92-5F982F48D047@microsoft.com...
> How do you countif for 2 conditions?
>
> countif ( A1 = "Red" and "B1 = blue")
>
> Bruce

[NNNNN]

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

"Bruce" <Bruce@discussions.microsoft.com> 撰寫於郵件新聞:0045152E-8139-4D47-9E92-5F982F48D047@microsoft.com...
> How do you countif for 2 conditions?
>
> countif ( A1 = "Red" and "B1 = blue")
>
> Bruce