How to add a number to a cell in Excel for a running total?

[Drukk]

I don't know if this is possible but can you add a number to the existing number in a cell just by overlaying that number onto the cell?

I.E. Cell shows 10, I then type 5 into the cell and it will automatically add it and display 15?

 

[vsmora]

Not possible directly as you would be creating a "circular reference" where the cell value is a function of itself. It may be possible to bodge something that appears to behave in the same way by spending some time programming macros. Much easier to redesign the sheet to "fit" how spreadsheets work (or just use a calculator )

 

[Drukk]

Ok , thanks for letting me know , I will abandon that idea then.