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

[Guest]

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

 

[Don Guillett]

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

 

[Guest]

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