Hi!

Try this:

D1 = start date
E1 = end date

Sum values in column B where the corresponding dates in column A fall within
the date range (inclusive):

=SUMIF(A1:A20,"="&D1,B1:B20)-SUMIF(A1:A20,""&E1,B1:B20)

Or:

=SUMPRODUCT(--(A1:A20=D1),--(A1:A20<=E1),B1:B20)

Biff

"garlocd" wrote in message
...
I need to be able to sum one column based on dates in another column.

Thankful for any help on this.