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

Repost for clarification and hopefully a quicker answer....
Sorry for the repost I tried to calrify yesterday but probably better to
start all over

My data is in A1:G12 I need a formula that will find the max of B2:G2, then
in that column count the cells 0 where the value in ColA is DOG.

something like countif(max(b2:G2),A:A="DOG")

I believe it will take sumproduct to accomplish but I can not figure it out.

Thanks!