Your formula works fine! Thank you and thank you also to all others who
contributed to my posting.
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Yes, the formula would be entered into C80


BTW............get rid of the <space after =SUM


Gord

On Wed, 16 May 2007 13:02:09 +0100, "Zygy" wrote:

Just to make it absolutely sure I have the formula right. My entries in
Col.C are up to line 79, so my formula to enter in Col.C line 80 should
read -

=SUM (C1:INDEX(C:C,ROW()-1)) Am I correct?

"Gord Dibben" <gorddibbATshawDOTca wrote in message
. ..
Zygy

Assuming your current data is in A1:A10

Enter this in A11

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

As you insert rows above A11 it will include the new rows.


Gord Dibben MS Excel MVP

On Tue, 15 May 2007 13:42:56 +0100, "Zygy" wrote:

Hi,

I tried it and it worked only when I included the additional lines in
the
Sum but when I added another line after that your suggestion did not
work.
So, what did I do wrong?
Incidentally this is on Office 2000.


"Gordon" wrote in message
.. .
"Zygy" wrote in message
...
How do I arrange for the sum totals in the last line on a worksheet
with
several columns of figures will automatically adjust itself when I
enter
an additional line or lines of figures, so that I do not have to use
the
totalling tool every time I make entries on the worksheet.



Make sure that the range summed contains one or more extra rows - then
just insert your new rows before the end of the range....