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 |
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 |
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 |
All times are GMT +1. The time now is 04:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com