I would suggest just using:

=SUM(A:A)

However, if you need to specify a range in col. A, try:

=SUM(OFFSET(A1,,,COUNT(A1:A30)))

which starts to sum at A1.

HTH
Jason
Atlanta, GA


-----Original Message-----
What is the formula for the sum a column of numbers
which is periodically
added to. I need to create the revised total
automatically as the insetion
of new data occurs.
.