Sum Column by Date Range
 

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.

Sum Column by Date Range
 

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)

--
Biff
Microsoft Excel MVP


"Lexi" wrote in message
...
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.

Sum Column by Date Range
 

THANKS, WORKED GREAT!!!

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Lexi" wrote in message
...
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.

Sum Column by Date Range
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Lexi" wrote in message
...
THANKS, WORKED GREAT!!!

"T. Valko" wrote:

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)

--
Biff
Microsoft Excel MVP


"Lexi" wrote in message
...
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.