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