Calculating a sum with running total and replacement

M

Mouse

Does anyone know how to add e.g B2 to C2 = D2 with the result of D2 replacing
B2 after result is shown in D2. B2 (0) + C2 (3) = D2 (3) turns to B2 (3) +
C2 (Blank) = 3 and so on.
 
N

Niek Otten

Excel really wasn't designed to things like that.

But you could take a look here:

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Does anyone know how to add e.g B2 to C2 = D2 with the result of D2 replacing
| B2 after result is shown in D2. B2 (0) + C2 (3) = D2 (3) turns to B2 (3) +
| C2 (Blank) = 3 and so on.
 
M

Mouse

Bugger I am trying to use an excel sheet to replace our Point of Sale when
our Wireless Network goes down as we are continually having problems, and a
few of the workers have trouble understanding computers. I was trying to
make it fool proof. Thanks anyway.
 
Top