| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total by date
I have to following table:
Date Amount Total 1-Jan-07 0:15 0:15 2-Jan-07 0:15 0:30 3-Jan-07 0:20 0:50 1-Feb-07 0:10 0:10 10-Feb-07 0:10 0:20 12-Feb-07 0:30 0:50 2-Mar-07 1:00 1:00 20-Mar-07 0:25 1:25 and so on What formula do I use on column "C" so that it keeps a running total for only that month (date being on column "A"). Regards -- capt |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Running total by date
Hi,
In C1 put the formula =B1 Then in C2 put the formula =IF(MONTH(A2)=MONTH(A1),B2+C1,B2) Drag down as required Mike "capt" wrote: I have to following table: Date Amount Total 1-Jan-07 0:15 0:15 2-Jan-07 0:15 0:30 3-Jan-07 0:20 0:50 1-Feb-07 0:10 0:10 10-Feb-07 0:10 0:20 12-Feb-07 0:30 0:50 2-Mar-07 1:00 1:00 20-Mar-07 0:25 1:25 and so on What formula do I use on column "C" so that it keeps a running total for only that month (date being on column "A"). Regards -- capt |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Running total by date
Thanks Mike,
It works fine, just the job......cheers! -- capt "Mike H" wrote: Hi, In C1 put the formula =B1 Then in C2 put the formula =IF(MONTH(A2)=MONTH(A1),B2+C1,B2) Drag down as required Mike "capt" wrote: I have to following table: Date Amount Total 1-Jan-07 0:15 0:15 2-Jan-07 0:15 0:30 3-Jan-07 0:20 0:50 1-Feb-07 0:10 0:10 10-Feb-07 0:10 0:20 12-Feb-07 0:30 0:50 2-Mar-07 1:00 1:00 20-Mar-07 0:25 1:25 and so on What formula do I use on column "C" so that it keeps a running total for only that month (date being on column "A"). Regards -- capt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rolling running total by date | Excel Discussion (Misc queries) | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| running total by date (not sorted by date though...) | Excel Worksheet Functions | |||
| Running Total | Excel Worksheet Functions | |||
Linear Mode
