How to total itmes if they fall between a date range

[cel]

I have a range of items that fall under a date range.
I am trying to total the items that fall under a certian date range.

ie.
20-Apr-05 25-Apr-05 1-May-05 16-May-05
A $1.00 $0.00 $0.00 $0.00
B $19.00 $0.00 $10.00 $0.00
C $0.00 $5.00 $0.00 $0.00
D $0.00 $0.00 $0.00 $20.00
total $20.00 $5.00 $10.00 $20.00

If dates fall between 1-Apr-05 and 30-Apr-05, total totals = $25.00
If dates fall between 1-May-01 and 31-May-05, total totals = $30.00
If dates fall in the year 2005, total totals = $55.00

How do I do this?

 

[Jason Morin]

Try:

=SUMPRODUCT(--(1:1>=D14),--(1:1<=E14),6:6)

where:

*row 1 contains date headers
*row 6 contains column totals
*D14 is the start date
*E14 is the end date

To do an entire year, specify 1-Jan-05 and 31-Dec-05.

HTH
Jason
Atlanta, GA