Adding Two columns

  • Thread starter Thread starter Praveen Kumar H S
  • Start date Start date
P

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
 
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.
 
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
 
Back
Top