How to total itmes if they fall between a date range
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? |
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? |
All times are GMT +1. The time now is 04:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com