Adding row without messing things up.

[Iotrez]

Hi all,

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

Thanks alot.

[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


On Thu, 10 Aug 2006 18:38:22 -0400, Iotrez
<[email protected]> wrote:

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