Hello Teethless

I have just tested your solution. And it actually has the right behavior
when inserting a new line. Thank you very much.

Now I just have to figure out how to insert a line with the right formulas
with one key combination. But this must be a simple operation described
somewhere in the documentation.

"Teethless mama" wrote:

=INDIRECT("B"&ROW()-1)+INDIRECT("A"&ROW())


"HPH" wrote:

How do I insert a new line in a excel spreadsheet without destroying the
consistency of the formulas?

Cut down to a minimum, the following is what I want.

Starting point:
B2=B1+A2
B3=B2+A3

Desired result after inserting a new line BETWEEN line 2 and line 3:
B2=B1+A2
B3=B2+A3
B4=B3+A4

I have been using SuperCalc for many years now, where this is a very simple
command. But I have newer been able to make the shift to excel. Just because
I could not figure out how to make this simple insert.
I have been trying at least four different types of relative referencing,
but they are all producing the wrong result:
B2=B1+A2
B3=<empty
B4=B2+A4