ExcelBanter - Sumproduct help

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

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

- - Sumproduct help (https://www.excelbanter.com/excel-worksheet-functions/131364-sumproduct-help.html)

Sandy

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!

Toppers

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!

Sandy

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!

All times are GMT +1. The time now is 12:46 AM.