| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rolling sums
Hi,
I have a column of data that contains daily sales (i.e. Column D). I want to create another column next to it that has a rolling sum (i.e. Column E). So each day it would sum the most current value that has been imputed into column D for the whole month. How do you create a rolling sum for the month? Thanks, -- Chuck W |
|
#2
|
|||
|
|||
|
Assume your daily sales start on row 1, enter this formula into E1:
=SUM($D$1:D1) and drag down. -- Regards, Dave "ChuckW" wrote: Hi, I have a column of data that contains daily sales (i.e. Column D). I want to create another column next to it that has a rolling sum (i.e. Column E). So each day it would sum the most current value that has been imputed into column D for the whole month. How do you create a rolling sum for the month? Thanks, -- Chuck W |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rolling time period | Excel Worksheet Functions | |||
| rolling year in excel | Excel Worksheet Functions | |||
| Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions | |||
| Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
| Calculating rolling sums | Excel Worksheet Functions | |||
Linear Mode
