Try:
=SUMPRODUCT(--(1:1=D14),--(1:1<=E14),6:6)
whe
*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
"cel" wrote:
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?
|