Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
suming working ok but now not auto updating totals after changes | Excel Discussion (Misc queries) | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
how to enter totals and sub totals from receipts into excel. | New Users to Excel | |||
Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |