Adding Two columns

[Praveen Kumar H S]

Hi All,

I want to Add two columns and store the sum in Third
Column. Explanation is like this:

Value of Column A = 2,
Value of Column B= 3
Sum in Column C = 5.

Second time when user updates Value of A to 5 Then the sum
should become 10. Here Old Value 2 and New value 5 also
should be retained.

Same condition should work for Column B also.

If any one knows the solution please let me know.

Regards,
Praveen Kumar H S

 

[Akshay Bakhai]

In cell C1, put in the obvious formula = A1 + B1


In cell C2, put in the formula = C1 + A2 + B2.

Copy cell C2 downwards to as many cells as you have.

Enter new values for A in the first available blank row in
column A. Respectively for B.

 

[Praveen Kumar H S]

Hi Akshay,

Thanks for the solution. But it is not working as per my
requirement.

Once again My requirement is like this.

Enter Value in Column A1 = 2
Enter Value in Column B1 = 3
Sum in Column C1 = 2+3 = 5. OK

If I change A1 from existing value 2 to 5 The Sum in
Column C1 should become A1(2+5) + B1(3) = 10. It should
consider the old value given in Column A1. Column A1
should hold the latest value entered.

Same should be applicable to all the Column B as well.

Regards,
Praveen