Sumproduct help

[Guest]

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!

 

[Guest]

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:G12>0))

 

[Guest]

Im sorry max B1:G1. Max of cells in the Row1 and cells in ColA that contain
"DOG"