Adding row without messing things up.

  • Thread starter Thread starter Iotrez
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically numbering rows 2
adding rows into the table 1
transferring data to new multiple spreadsheets 1
Hide rows in table based on 1 empty cel of the same row. 1
Retrieving data from a cell in the last row containing data in the worksheet 1
Table no longer copies formulas to new rows 9
Adding Row an keepin correct SUM 4
Combine Lists 1

Back
Top