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

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 :-

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 :-
2.Enter the following formula in any cell :-


Posted by Celia on January 26, 2001 7:41 PM


The formula =SUM(COSTS) cannot be put in column A.