Continuous Addition
 

What formula do I use to keep a running total in a column on my spreadsheet?

Depends on exactly what you want to display in the column returning the
total, when the column containing the numbers is empty (not yet filled).

Numbers in Column A:

Enter this in B1, and copy down as needed:
=SUM($A$1:A1)
This displays the *last* total, all the way down the column, as far as the
formula is copied.

=(A1<"")*SUM($A$1:A1)
This displays 0's when there's no number in the Column A row.

=IF(A1,SUM($A$1:A1),"")
This displays an empty cell when there's no number in the Column A row.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Precious Singleton" wrote in
message ...
What formula do I use to keep a running total in a column on my
spreadsheet?