Rolling sums

[ChuckW]

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

[David Billigmeier]

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