many input in 1 cell, total result in other cell?

Originally Posted by docthusinh

Hi, I am new to this forum and beginner to excel. I have a question on how to do this:

- For example in my sheet, I want cell A1 to be a number input cell, A2 is sum cell .
- Every time I key in number in A1, it automatically add that value into A2 cell (A2 will be the total of whatever number every time I typed in A1).

Something like this: at the beginning, A1 =empty, A2 =0.
1st: Input 10 to A1 then A2=10
2nd: input 12 to A1 then A2=22
3rd: input 13 to A1 then A2=25


Please help on how to do formula for this A2.
Thank you.

Hi,

Windows provides a program under 'Accessories' called CALCULATOR which does that very well.

Excel has no formula that I would recommend that does this, however as this question arises about every second month there is some VBA code which will suffice, see http://www.excelforum.com/showthread.php?t=606583 which adds the contents of cell A2 back into A1

hth
---

Originally Posted by docthusinh

Thank for your suggest but I don't understand and can't do with that post in link you given.

It like a simple math:
a=a+b, input b.

Remember back when i am in high school, my IT teacher taught me, there is functions in excel, but....long time.

I would hope that you were not taught that in any school.

In A2

=A1+A2

will give you what you ask, however this also produces a circular reference, and I do not believe that your experience with Excel is sufficient for you to correctly control a circular.

hth
---