Sum Column by Date Range

[Guest]

I have 2 columns, one with date the other with $amounts. I want to sum the
$amounts, but only by a date range,(ie 2/10/07-9/07/07).

Date Amount
1/1/2006 125
2/10/2007 50
9/07/2007 25

I need help with a fomula for this.

 

[T. Valko]

One way:

=SUMIF(A1:A3,">="&DATE(2007,2,10),B1:B3)-SUMIF(A1:A3,">"&DATE(2007,9,7))

Better to use cells to hold the date range:

D1 = 2/10/2007
E1 = 9/7/2007

=SUMIF(A1:A3,">="&D1,B1:B3)-SUMIF(A1:A3,">"&E1,B1:B3)

 

[Guest]

THANKS, WORKED GREAT!!!

One way:

=SUMIF(A1:A3,">="&DATE(2007,2,10),B1:B3)-SUMIF(A1:A3,">"&DATE(2007,9,7))

Better to use cells to hold the date range:

D1 = 2/10/2007
E1 = 9/7/2007

=SUMIF(A1:A3,">="&D1,B1:B3)-SUMIF(A1:A3,">"&E1,B1:B3)

 

[T. Valko]

You're welcome. Thanks for the feedback!