Summing To Same Cell Reference
 

I have the the following values in cells indicated:

A1 = 40
A2 = 60
A3 = 150
========
A1 =150
========

I need the figures add up to first cell. I applied this formula without success RC = "=RC+ R[+1]C+R[+2]C"

Summing To Same Cell Reference
 

hi,

https://support.office.com/en-us/art...rs=en-US&ad=US
Learn about iterative calculation

isabelle

Le 2015-04-13 11:52, a écrit :

I have the the following values in cells indicated:

A1 = 40
A2 = 60
A3 = 150
========
A1 =150
========

I need the figures add up to first cell. I applied this formula without success RC = "=RC+ R[+1]C+R[+2]C"