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