MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.