Formula to sum for different date ranges
On Dec 1, 2:27 pm, confused in tn <confused in
wrote:
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
|