Thread: Sumproduct help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default 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!