How to Get a Running Total by Subtraction in Excel 2007

1. Enter the numbers you want to subtract from beginning total in a column on the left. For example, if you want to subtract 10, 14, 19 and 16 from 1000, you would place 10, 14, 19 and 16 in cells A2, A3, A4 and A5. Place the beginning total in a second column. For example, 1000 would go into cell B1.
2. Write the formula for the running subtraction, or balance. In cell B2, type '=SUM(B1-A2)'. This will subtract 10 from 1000 and put the result, 990, in cell B2.
3. Copy the formula to the lower cells to create a running total. Click on cell B2. Move the cursor to the bottom right corner, then click and drag the cell downward to drag the formula down the column. This will copy the formula to the lower cells so you won't have to rewrite the formula for each cell.