=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