Add a number to a same cell

  • Thread starter Thread starter Earl Kiosterud
  • Start date Start date
E

Earl Kiosterud

Bobby,

Only an event macro could let you type a number, and keep a running total in
the same cell.

There's a rash of making accumulators like that, and it's not really a good
idea. Here's my standard blurb on it. It speaks of a running total in a
cell, and entering numbers via another cell, but the idea is the same. Same
caveats.

Running total in a cell using a circular reference
It's possible to have a cell keep a running total of numbers entered
into another cell, but not a good idea

You do it like this:
A1: a number
A2: =A1+A2

Any number entered into A1 gets immediately summed with the current
total in A2.

You must use Tools - Options - Calculation - Iterations: 1

The reason this is not a good solution is that you have no audit trail
of the numbers that have been summed. The formula cell just eats them up.
How do you know if a particular entry was ever made or not? Also, if Undo
is used, the total doesn't get backed down, it goes up. It's much better to
list the numbers, and total with with a SUM() formula.
 
Hi, The only solution I can think of is, click into the cell with the
number in it, click = in the formula bar at the top then type + whatever
number you want and press enter. The cell will update. Pauline
 
Hi, thanks for reading this.
Have a problem, say in cell A1 I type a number like 500 into it, and
when I hit enter I want it to add say 525 to that number and then
display in in the same cell A1. Is this possible? or am I asking too
much from Excel. I know I can have it display in a different cell but,
this is what I want.

Thanks for any help.
Bobby
 
Back
Top