Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Running Totals
I wish to be able to store running totals in my Spread
sheet. If I have values in A1:A10 for example, how would I add the values to B1:B10 respectively. Once they are added up, the Values from the formulas in A1:A10 will be cleared by my Macro. Basically, all I want is a formula to add A1:A10+B1:B10 then hold the values in B1:B10. After the sheet has been filled in again, I would like to repeat the process, keeping the B column as a running total. Pete |
#2
|
|||
|
|||
Pete
In B1 enter =IF(A1<"",A1,"") In B2 enter =IF(A2<"",B1 + A2,"") Drag/copy B2 down to B10 Gord Dibben Excel MVP \On Tue, 22 Mar 2005 12:41:58 -0800, "Pete" wrote: I wish to be able to store running totals in my Spread sheet. If I have values in A1:A10 for example, how would I add the values to B1:B10 respectively. Once they are added up, the Values from the formulas in A1:A10 will be cleared by my Macro. Basically, all I want is a formula to add A1:A10+B1:B10 then hold the values in B1:B10. After the sheet has been filled in again, I would like to repeat the process, keeping the B column as a running total. Pete |
#3
|
|||
|
|||
Just another way:
=SUM($A$1:A1) And copy down as needed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Pete In B1 enter =IF(A1<"",A1,"") In B2 enter =IF(A2<"",B1 + A2,"") Drag/copy B2 down to B10 Gord Dibben Excel MVP \On Tue, 22 Mar 2005 12:41:58 -0800, "Pete" wrote: I wish to be able to store running totals in my Spread sheet. If I have values in A1:A10 for example, how would I add the values to B1:B10 respectively. Once they are added up, the Values from the formulas in A1:A10 will be cleared by my Macro. Basically, all I want is a formula to add A1:A10+B1:B10 then hold the values in B1:B10. After the sheet has been filled in again, I would like to repeat the process, keeping the B column as a running total. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table (Running Averages) | Excel Worksheet Functions | |||
timesheet with running totals of overtime | Excel Worksheet Functions | |||
running totals | Setting up and Configuration of Excel | |||
RUNNING TOTALS | Excel Discussion (Misc queries) | |||
running totals in a macro for each month | Excel Worksheet Functions |