LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Jeanette
 
Posts: n/a
Default SUMPRODUCT by Date (numeric) value

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumproduct for latest date Sue Excel Worksheet Functions 9 August 3rd 05 09:30 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Sumproduct with Date column JerryS Excel Worksheet Functions 2 June 6th 05 11:45 PM
Using sumproduct to count number by date JerryS Excel Worksheet Functions 2 June 6th 05 10:37 PM
SUMPRODUCT with date range question Rob V Excel Discussion (Misc queries) 1 January 31st 05 03:55 PM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"