Adding row without messing things up.

I

Iotrez

Hi all

If I have 9 rows of data and then a row 10 containing formulas, is i
possible to add another row of data after row9 and have the formula ro
move automatically to row 11 without having to copy and paste it

Thanks alot
 
G

Gord Dibben

Assum you had numbers in A1:A9 and in A10 you had

=SUM(A1:A9)

If you insert a row above row 10 by selecting A10 and Insert>Cells>Shift Down,
the SUM formula will move down to A11 and be

=SUM(A1:A10)

Is that what you need? Or is that not happening?

If not, try this formula in A10

=SUM(A1:INDEX(A:A,ROW()-1))


Gord Dibben MS Excel MVP
 
Top