CUMULATIVE TOTAL
 

I created a worksheet with some formulas in it. I would
like to be able to add other worksheets at the end as
required using the copy command. I would be changing the
data in these new added-on worksheets. I need a "running
total" formula that will total specified cells from
existing sheets and incorporate the data from any new
sheet added at the end.

How can I do this?

If you are summing like

=SUM(Sheet1:Sheet3!D1:D20)

create 2 empty dummy sheets that always will be the first and last sheets
and include
them in the sum

=SUM(First:Last!D1:D20)

then when you add sheets you always put them in-between these 2 sheets, that
way your sum will always be updated
without changing the formula


Regards,

Peo Sjoblom



"Norm" wrote in message
...
I created a worksheet with some formulas in it. I would
like to be able to add other worksheets at the end as
required using the copy command. I would be changing the
data in these new added-on worksheets. I need a "running
total" formula that will total specified cells from
existing sheets and incorporate the data from any new
sheet added at the end.

How can I do this?