| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Linear Mode
