Sum of two cells

Occasional Visitor

I have a case that I have to sum two cells and the result should appear in the second cell. 

For example:




Once I update the 30 to 60, the result should show up on the second cell, but plus the current value of the second cell:




Can someone help how to add current value and another value from another cell?

1 Reply


I'm afraid this is not a good idea:

  • It would cause a circular reference.
  • You'd have no way to check and correct mistakes.

Place the sum formula in a third cell instead.