Totals & updating totals

[Guest]

Columns a,b,c added for totals in column D
Next day, new numbers are placed in a,b,c. Simple way to have the number in
D stay put (not change) but give you the new grand total

 

[Tom Ogilvy]

You want to accumulate totals in D. Best approach is to use a new sheet
each day and accumulate values (=sum(Start:End!D1) - your data sheets are
placed between sheet Start and sheet End in the tab order) in a summary
sheet. Next best is to generate the sum with a macro, rather than a
formula. Almost any other approach is guaranteed to be inaccurate.