Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Continuous Addition
What formula do I use to keep a running total in a column on my spreadsheet?
|
#2
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Continuous Services Dates | Excel Worksheet Functions | |||
help with simple addition formula | Excel Worksheet Functions | |||
3D Chart with Continuous Data in all three Axes | Charts and Charting in Excel | |||
CAN I INSTALL EXCEL ON MY XP HOME ADDITION LAPTOP ? | Excel Discussion (Misc queries) | |||
Addition worksheet generator | Excel Worksheet Functions |