Just sum from the cell below the sum formula to the last cell of the column.
The following could be placed in cell A1. It is for xl2007. Earlier versions
do not have as many rows. Note: You can't include the cell where the formula
is because you would get a circular reference.

=SUM(A2:A1048576)
--
Regards,

OssieMac


"a m spock" wrote:

I have a data table to which fresh rows keep getting added evry now and then.
how to i put a toal at the top of a column which will refresh everytime a
fresh row is added.