Calculate Total Expenses Tutorial Home >Software >Finance >Microsoft Works 2000 Projects >Household Budget >Calculate Total Expenses Tutorial Home >Software >Office >Microsoft Works 2000 Projects >Household Budget >Calculate Total Expenses Tutorial Home >Software >Publishing >Microsoft Works 2000 Projects >Household Budget >Calculate Total Expenses   Step 1:  Modify Expense Cell You need to enter the cell address of the total expenses in cell D7. Unfortunately, the worksheet does not include a cell that contains the total expenses expressed as a formula. You need to enter a formula in cell D7 that will add all the expenses subtotals. First, click cell D7 to select it,. then type the equals sign (=) to start the formula.   Step 2:  Select an Expense Cell The first cell containing an expense subtotal is cell D27 that represents the total withholdings expenses. Scroll down the worksheet and click cell 27, then type a plus sign (+).   Step 3:  Complete the Formula To complete the formula, you need to continue clicking on cells containing expense subtotals and then entering plus signs. Here's how the completed formula should appear in the formula bar.   Step 4:  Confirm the Formula Press the Enter key to make the calculation, then click cell D7 so you can see the formula. The value that appears in cell D7 will not have changed since you haven't yet changed any of the expenses.   Step 5:  Test the Formula Click cell D21 and change the federal income tax to 150. The total withholdings expense changes from 688.00 to 390.00 in cell D27, and the total expenses in cell D7 changes from 4,977.25 to 4,679.25. Notice how the value in cell D8, which represents the difference between the income and the expenses, also changes.