#1   Report Post  
Precious Singleton
 
Posts: n/a
Default Continuous Addition

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

  #2   Report Post  
RagDyer
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for Continuous Services Dates pvbridges Excel Worksheet Functions 1 June 19th 05 01:51 AM
help with simple addition formula Juco Excel Worksheet Functions 1 January 29th 05 12:51 PM
3D Chart with Continuous Data in all three Axes Barb Reinhardt Charts and Charting in Excel 3 January 10th 05 07:09 PM
CAN I INSTALL EXCEL ON MY XP HOME ADDITION LAPTOP ? AC_MAN45 Excel Discussion (Misc queries) 4 December 1st 04 12:05 AM
Addition worksheet generator Sriram Excel Worksheet Functions 2 November 20th 04 08:11 AM


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"