Hi

On your Summary Sheet
=SUM(Sheet1:Sheet31!A1)

Since data will presumably not have been entered into dates beyond say
27th, the Sum will effectively only be from Sheet1 to Sheet27 and
therefore the running total.

Alternatively, create 2 extra sheets called First and Last and make the
formula
=Sum(First:Last!A1)
Drag First and Last to a position to "sandwich any of the range 1 to 31,
and the result will be the total for just those sheets.

--
Regards

Roger Govier


"Skydiver" wrote in message
...
I have 31 worksheets for everyday of the month. In each sheet I'm
summing up
several different figures. I would like to insert another worksheet
and
maintain a running total from each sheet. Can you help?