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

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

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

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