how do i keep adding to existing total in same row

[marklessexcel]

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

 

[Niek Otten]

Look here:

http://www.mcgimpsey.com/excel/accumulator.html

 

[Gord Dibben]

And make note of the caveat about having no "paper trail" to check for data
entry errors.


Gord Dibben MS Excel MVP

 

[Niek Otten]

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.