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

--
Iotre
-----------------------------------------------------------------------
Iotrez's Profile: http://www.excelforum.com/member.php...fo&userid=3736
View this thread: http://www.excelforum.com/showthread.php?threadid=57056

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
<(E-Mail Removed)> 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.