Kjell,

That's the same formula that he has, just in RC notation. It has the
same problem that he is talking about.

HTH,
Bernie
MS Excel MVP

"Kjell" wrote in message
...
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