Count function in excel with different conditions

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.

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

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


"chits" <[email protected]> wrote in message
news:[email protected]...
>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.