Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am currently working on the following document excerpt
Worklist Received Reported Days to Report AUT 5/16/2005 6/7/2005 22 AUT 6/28/2005 6/28/05 BM 1/3/2005 1/4/2005 1 BM 1/3/2005 1/6/2005 3 I am trying to find out the number of "worklist" items per month (Received) and then divide the number of "Days to Report" by that number to get the average days per item. The following calculation I have is not working on "numeric values" my formula:=SUMPRODUCT(--(IndexData!$G$5:$G$23330=1/1/2005),--(IndexData!$G$5:$G$23330<=1/31/2005),--(IndexData!$A$5:$A$23330="BM")) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct for latest date | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Sumproduct with Date column | Excel Worksheet Functions | |||
Using sumproduct to count number by date | Excel Worksheet Functions | |||
SUMPRODUCT with date range question | Excel Discussion (Misc queries) |