Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 921
Default Totals & updating totals

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
--
jeff w
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Totals & updating totals

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.

--
Regards,
Tom Ogilvy

"Jeff" wrote in message
...
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
--
jeff w



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
suming working ok but now not auto updating totals after changes colin bellamy Excel Discussion (Misc queries) 1 March 16th 08 11:09 PM
Pivot Totals: Group totals different from Grand totals PsyberFox Excel Discussion (Misc queries) 1 February 13th 08 06:16 PM
how to enter totals and sub totals from receipts into excel. mjd23 New Users to Excel 2 January 11th 08 01:54 AM
Summing Weekly Totals into Monthly Totals steph44haf Excel Worksheet Functions 3 July 5th 06 04:51 PM
Comparing/matching totals in a column to totals in a row Nicole L. Excel Worksheet Functions 3 January 27th 05 10:42 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"