Use cells to hold the date boundries.

Date in A1:A10
Values to sum in B1:B10

D1 = lower date boundary = 4/1/2008
E1 = upper date boundary = 6/30/2008

Then:

=SUMIF(A1:A10,"="&D1,B1:B10)-SUMIF(A1:A10,""&E1,B1:B10)

Format as General or Number

--
Biff
Microsoft Excel MVP


"confused in tn" <confused in wrote in message
...
I need a formula to total for quarterly date ranges. For example: if a
payment was received during 4/1/08 - 6/30/08 sum the payments.