I have a list that where I add info that are then summed up in each column.
Problem I have is that I have to add new rows after filled rows to Row 19
To add a row function. No probs to do that manually. But I want to do it
automatically. It does not matter.
Is it possible?

Row 1 One Two Three
Row 2 Four Five Six
Row 3 Seven Eight Nine
Row 4
Row 5
Row nn
Row19
Row 20 Add Column A Add column B Add column C

Hi

If you are using XL2003, place your cursor in cell A1DataListuncheck My
List has headers
DataListTotal

Repeat the formula you see in C20, in B20 and A20.

As you add more rows, the total row will move down automatically.

--
Regards
Roger Govier

"MSSailor" wrote in message
...
I have a list that where I add info that are then summed up in each
column.
Problem I have is that I have to add new rows after filled rows to Row 19
To add a row function. No probs to do that manually. But I want to do it
automatically. It does not matter.
Is it possible?

Row 1 One Two Three
Row 2 Four Five Six
Row 3 Seven Eight Nine
Row 4
Row 5
Row nn
Row19
Row 20 Add Column A Add column B Add column C

Sorry did not mention that I have XL2000.
Thanks for telling


"Roger Govier" wrote:

Hi

If you are using XL2003, place your cursor in cell A1DataListuncheck My
List has headers
DataListTotal

Repeat the formula you see in C20, in B20 and A20.

As you add more rows, the total row will move down automatically.

--
Regards
Roger Govier

"MSSailor" wrote in message
...
I have a list that where I add info that are then summed up in each
column.
Problem I have is that I have to add new rows after filled rows to Row 19
To add a row function. No probs to do that manually. But I want to do it
automatically. It does not matter.
Is it possible?

Row 1 One Two Three
Row 2 Four Five Six
Row 3 Seven Eight Nine
Row 4
Row 5
Row nn
Row19
Row 20 Add Column A Add column B Add column C

Hi,

Unfortunately the List feature did not get introduced until 2003. In
earlier versions you might:

Set up a total further down which sums everything =SUM(A1:A50) for example,
even though you don't have data yet for many of the rows. Then you can
"move" the total row up by applying a Data, Filter, AutoFilter command to the
range A1:A51, and choosing NonBlanks from the auto filter dropdown.

Alternatively you could write code.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MSSailor" wrote:

Sorry did not mention that I have XL2000.
Thanks for telling


"Roger Govier" wrote:

Hi

If you are using XL2003, place your cursor in cell A1DataListuncheck My
List has headers
DataListTotal

Repeat the formula you see in C20, in B20 and A20.

As you add more rows, the total row will move down automatically.

--
Regards
Roger Govier

"MSSailor" wrote in message
...
I have a list that where I add info that are then summed up in each
column.
Problem I have is that I have to add new rows after filled rows to Row 19
To add a row function. No probs to do that manually. But I want to do it
automatically. It does not matter.
Is it possible?

Row 1 One Two Three
Row 2 Four Five Six
Row 3 Seven Eight Nine
Row 4
Row 5
Row nn
Row19
Row 20 Add Column A Add column B Add column C