How to add multiple values in A cell and the result should be the next cell?

[kavithavaratharaj]

Hi to all,

Eg: I enter the value 2 in the cell A1 and the result should be 2 in B1. Again i enter the value of 5 in the same A1 like 2+5 then the result should be 7 in B1. Again i enter the value 44 in the same A1 like 2+5+43 then the result should be 50 in B1. Again i enter the value 10 in the same A1 like 2+5+43 +10 then the result should be 60 in B1.

When i add the values by using + sign in A1 and the result should be changed automatically in the next cell of B1.

Eg: A1 = 2+5+43 +10 (Input).
B1= 60 (Output)

Could you knindly help by providing formula.

Thank to all to respond my query

[AliGW]

Can't be done with a formula. You will need VBA for this. I will move the thread.

[kavithavaratharaj]

OK, but i do not know. Thank you very much

[AliGW]

That's why I am telling you and why I have moved the thread for you.

[XOR LX]

You can do this without VBA if you first go to File/Options/Formulas/Enable iterative calculation and set the Maximum Iterations box to 1.

Then type e.g. 2 in A1 and put the following formula in B1:

=A1+B1

Changing the value in A1 will now give the desired results in B1.

Regards

[KOKOSEK]

Put into Sheet code not as module.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A1")) Is Nothing Then
        Range("B1").Value = Range("B1").Value + Range("A1").Value
    End If
End Sub