How do I Autosum a running column total in excel?

[JR5280]

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.

 

[Jason Morin]

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

 

[Keith]

Try this:

A1=SUM(B:B)

where a1 is the running total of column B

Keith