How can I sum information in a list with a date range?
 

How can I sum information in a list with a date range?
My start date is 11/1/04 and my end date is 11/18/04.
I want to sum the "GOOD' column that falls in the date range.

DATE PART W/O # GOOD
11/12/04 2177-2027 2512479 2500
12/01/04 FS9747 2519859 100
10/31/04 2342-00302 2575360 0
12/01/04 2342-00302 2575360 25
11/16/04 2342-00302 2575361 18215


Thanks

try where b1 and b2 have your start/stop dates
=sumproduct((rngAb1)*(rngA<b2)*goodrng)

--
Don Guillett
SalesAid Software

"Dave" wrote in message
...
How can I sum information in a list with a date range?
My start date is 11/1/04 and my end date is 11/18/04.
I want to sum the "GOOD' column that falls in the date range.

DATE PART W/O # GOOD
11/12/04 2177-2027 2512479 2500
12/01/04 FS9747 2519859 100
10/31/04 2342-00302 2575360 0
12/01/04 2342-00302 2575360 25
11/16/04 2342-00302 2575361 18215


Thanks

=SUMIF(A2:A6,"="&DATEVALUE("11/1/2004"),D2:D6)-SUMIF(A2:A6,""&DATEVALUE("11/18/2004"),D2:D6)

"Dave" wrote:

How can I sum information in a list with a date range?
My start date is 11/1/04 and my end date is 11/18/04.
I want to sum the "GOOD' column that falls in the date range.

DATE PART W/O # GOOD
11/12/04 2177-2027 2512479 2500
12/01/04 FS9747 2519859 100
10/31/04 2342-00302 2575360 0
12/01/04 2342-00302 2575360 25
11/16/04 2342-00302 2575361 18215


Thanks