"stuhag" wrote in message
...
Hi
I have a kin a formula wich gets the value from the cell above and then
add
some.
What I get is an list of values incrementing.

When I delete one row in this list, all cells below 'crashes' with #REF!.
What I need is that for the formulas to always look one cell up, even if I
delete a row. Now it seems that if I delete Row8, then when Row9 become
Row8
it reference to it self and then ov course goes bananas...

Hope I made myself understandable ;-)

Any ideas folks?

--------
stuhag
---------

As an example, from cell A10, OFFSET(A10,-1,0) will reference the cell above
it. So the formula
=SUM(A1:OFFSET(A10,-1,0))
put in cell A10 will add up the column of cells above this cell. If cells
are added or deleted above it, the formula adjusts automatically.
Is this what you need?