Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using sumproduct | Excel Discussion (Misc queries) | |||
SUMPRODUCT? | Excel Discussion (Misc queries) | |||
SUMPRODUCT | Excel Discussion (Misc queries) | |||
sumproduct ? | Excel Worksheet Functions | |||
Sumproduct Help | Excel Worksheet Functions |