View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kjell[_2_] Kjell[_2_] is offline
external usenet poster
 
Posts: 2
Default formula to follow preceeding value

Jepp

It's something like this "=SUM(R[-1]C)"

R = rows C= column and in this case the [-1] means current ROW -1 (but the same column :-)

"=SUM(R[-1]C[-1])" should thefore be one up and one left, and then you can add +1 or whatever....

Kjell