Totals & updating totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top