Formula to sum for different date ranges

[confused in tn]

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.

 

[T. Valko]

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

 

[Ken Johnson]

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.

One way, assuming payment dates are in A2:A1000 and payment amounts
are in B2:B1000...

=SUMPRODUCT(--($A$2:$A$1000>=DATE(2008,4,1)),--($A$2:$A$1000<=DATE
(2008,6,30)),$B$2:$B$1000)

Ken Johnson

 

[confused in tn]

Can I use the entire columns instead of a range of cells for the dates and
the payments?

 

[T. Valko]

If you're using Excel 2007 you can. If you're not using Excel 2007 you can
use entire columns with the SUMIF version but not the SUMPRODUCT version.