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" <[email protected]> wrote in message
news:[email protected]...
> 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.