Adding Calculation

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

Hello,

What I would like to do is have a cell keep adding a sum from another cell.
SAy I have two cells, A1 is going to have a number entered into it and B1 is
going to be the total of all the numbers put into A1. Also is it possible
after number is entered into A1 it resets back to zero, but B1 retains sum
of all numbers entered?

Thanks JR
 
A cell formula does not have memory. The only way to build in memory is
with VBA (You chould have a worksheet change event that updates B1 when
there is a change in A1, as suggested by Frank).

As a practical matter, memory in a calculation is almost always a bad
idea. How would you deal with data entry errors in R8? If the running
total somehow gets out of sync, how would you correct, or even detect it?

Jerry
 
Back
Top