ExcelBanter - Count function in excel with different conditions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count function in excel with different conditions (https://www.excelbanter.com/excel-worksheet-functions/9577-count-function-excel-different-conditions.html)

chits

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.

Rob van Gelder

=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.

All times are GMT +1. The time now is 02:49 PM.