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.