View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default 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"