| 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct help
I am confused: A2:A12 appear to contain text and yet you want to find the MAX
of A1:A12??? =SUMPRODUCT((A2:A12="DOG")*(B2:G120)) "Sandy" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumproduct help
Im sorry max B1:G1. Max of cells in the Row1 and cells in ColA that contain
"DOG" "Toppers" wrote: I am confused: A2:A12 appear to contain text and yet you want to find the MAX of A1:A12??? =SUMPRODUCT((A2:A12="DOG")*(B2:G120)) "Sandy" wrote: 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! |
| Reply |
| 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 | |||
Linear Mode
