Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i keep adding to existing total in same row
i want cells a & B to be incoming and out going numbers and cell c to total
accordingly. i have that part but want a & b cells to be reinputted band total change with new inputs so that total continues to grow or shrink with each new imput want to reuse same a & B cell agian and agian |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i keep adding to existing total in same row
Look he
http://www.mcgimpsey.com/excel/accumulator.html -- Kind regards, Niek Otten Microsoft MVP - Excel "marklessexcel" wrote in message ... i want cells a & B to be incoming and out going numbers and cell c to total accordingly. i have that part but want a & b cells to be reinputted band total change with new inputs so that total continues to grow or shrink with each new imput want to reuse same a & B cell agian and agian |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i keep adding to existing total in same row
And make note of the caveat about having no "paper trail" to check for data
entry errors. Gord Dibben MS Excel MVP On Fri, 17 Oct 2008 10:08:54 +0200, "Niek Otten" wrote: Look he http://www.mcgimpsey.com/excel/accumulator.html |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i keep adding to existing total in same row
Gord is absolutely right.
Consider these cells constants. That is, they are not part of the calculation model presented in Excel. They have about the same status as calculation results from a calculator, that you manually entered in Excel as input cells. If you use a spreadsheet the way it was meant, you can always recalculate all results manually (however long it might take....). The accumulator cells however can not considered to be part of the calculation model, they are just input cells. -- Kind regards, Niek Otten Microsoft MVP - Excel "Gord Dibben" <gorddibbATshawDOTca wrote in message ... And make note of the caveat about having no "paper trail" to check for data entry errors. Gord Dibben MS Excel MVP On Fri, 17 Oct 2008 10:08:54 +0200, "Niek Otten" wrote: Look he http://www.mcgimpsey.com/excel/accumulator.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding to an existing formula | Excel Worksheet Functions | |||
Adding an extra row after every existing row | Excel Discussion (Misc queries) | |||
adding a line to an existing chart | Charts and Charting in Excel | |||
adding on to an existing total & avoiding a circular reference blo | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |