| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM-ing date for different time intervals
I have the following case:
DATE VALUE 1.12.2006 100 4.12.2006 200 6.12.2006 250 7.12.2006 100 11.12.2006 1500 13.12.2006 250 14.12.2006 400 15.12.2006 950 27.12.2006 200 28.12.2006 30 29.12.2006 80 Now i'd like to SUM the values for specific time intervals, lets say: from 01.12.06 til 06.12.06 SUM=550 from 07.12.06 til 15.12.06 SUM= 3200 etc. I'd like to be able to change the time intervals and have a formula that sums the values for different chosen intervals! 10x for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| change date based on time | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
Threaded Mode
