How do I Autosum a running column total in excel?
 

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.

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.
.

Try this:

A1=SUM(B:B)

where a1 is the running total of column B

Keith




"JR5280" wrote in 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.