Running Totals

Posted by Widger on July 26, 2001 7:29 AM

Can anyone tell me if there is a formula that you can cut and paste to cells that will calculate a running total?

Posted by IML on July 26, 2001 7:45 AM

If your list starts in A1, try
=sum($a$1:a1) in say, cell B1
and copy it down as far as your list.
Or if data is being continually entered, use

=IF(NOT(ISBLANK(A1)),SUM($A$1:A1),"")

and copy it as far as you think data will be entered.

Good luck