Excel provides several methods for creating running totals. You can use a worksheet function like =SUM($A$1:A1) where the values to total (or subtract) are in column A and the formula is copied down column B.
See this link for a full explanation, illustrations, and some code that could be downloaded.
http://lacher.com/examples/lacher03.htm
Also see this link:
http://saturn.fab.albany.edu/ulans/excelTips.htm
"Create a Formula to Keep a Running Total in Excel"
In Microsoft Excel, you can calculate a running (or cumulative) total in a column or row of cells by using a combination of absolute and relative references in a formula that uses the SUM function.
>> REMOVE SPACES from the pasted URLs <<
Maxwell