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

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

--
Regards
Frank Kabel
Frankfurt, Germany

JR wrote:
> 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

JR wrote:

> 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