| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to total items if they fall between a date range | Excel Discussion (Misc queries) | |||
| Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
| how do i sum 2 values that fall between date ranges? | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
