=SUMPRODUCT((A1:A8="WHITE") * (B1:B8="RED"))

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"chits" wrote in message
...
I have the excel sheet with foll values:

A B
-----------------
BLACK BLUE
WHITE RED
YELLOW GREY
WHITE PINK
WHITE RED
ORANGE RED
YELLOW RED
BLACK GREEN


Sum of combinations with A=WHITE + B=RED equals:


I need to find out formula having conditions upon multiple column array..
does anyone have an idea on this?
Thanks.