Keep Ruuning total of a Field
Posted by Sam Smolker on January 26, 2001 4:43 PM
I have a simple inventory Excel spreadsheet. The user wants to keep a running total of the cost of individual items. Is there a way short of VBA code to do this on the worksheet? Thanks much...
Posted by Celia on January 26, 2001 7:37 PM
Sam
If you just want a running total in a column, then assuming the costs are in column A starting in A1, enter in B1 the following formula and fill down :-
=SUM(A$1:A1)
If you want the running total to be in one cell only :-
1.Assuning your data is on Sheet1, define a name called COSTS and enter the following formula in the refers to box :-
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
2.Enter the following formula in any cell :-
=SUM(COSTS)
Celia
Posted by Celia on January 26, 2001 7:41 PM
Note
The formula =SUM(COSTS) cannot be put in column A.
