I came across another solution yesterday on Contextures site.

=sum(b5:offset(b7,-1,0))

and this will adjust the rows for inserted rows without the blank.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"LurfysMa" wrote:

On Sat, 24 Feb 2007 19:19:00 -0800, Martin Fishlock
wrote:

Hi:

one way is to have a blank row between your data and your total
and set the height to 1.

then on your sums include the blank row and then you can insert a row after
the last data row and the sums will still work.

so in your example

Row Date Units Minutes U/M Comments
5 1/12/07 50 25 2.0 xxx
6 1/13/07 100 40 2.5 xxx
7
8 Totals =sum(b5:b7) =sum(c5:c7) =b8/c8 xxx

and then when you insert a row the references will be automatically adjusted:

Row Date Units Minutes U/M Comments
5 1/12/07 50 25 2.0 xxx
6 1/13/07 100 40 2.5 xxx
7 1/14/07 50 25 2.0 xxx
8
9 Totals =sum(b5:b8) =sum(c5:c8) =b9/c9 xxx

That works. It's a reasonable work-around.

I would think that there ought to be a straightforward way to add a
row to a table with sums and have the sums automatically update.

Thanks for the help.

--
Running Excel 2000 SP-3 on Windows 2000