Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct help
Hello
I have have an array of data A1:G12. I would like to find the max of A1:A12 and then count the the 0 Cells in B2:G12 where A2:A12= "DOG". How do I Add the MAX part to the formula? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct Help | Excel Discussion (Misc queries) | |||
Can this be done using Sumproduct? | Excel Worksheet Functions | |||
Like Sumproduct, But Different | Excel Worksheet Functions | |||
Sumproduct Help | Excel Worksheet Functions |