Microsoft Office Tutorials and References
In Depth Information
To calculate the total income and expenses for January using the
1. Click cell B8 on the Budget worksheet, type =SUM(B6:B7) and then press the Enter key.
Excel displays the value 3,250 in cell B8, indicating that the total income for the month of
January is $3,250.
You can also enter the cell range for a function by selecting the cell range rather than typ-
ing it. You’ll use this method to determine the total expenses for January.
2. Click cell B22 and then type =SUM( to begin the function.
3. Select the range B11:B21 using your mouse. As you drag to select the range, its cell refer-
ence is automatically entered into the SUM function, as shown in Figure 2-3.
Entering the SUM function
the formula appears
in the Formula bar
syntax for the
the range reference is automatically
entered into the function
4. Press the Enter key to complete the formula. Note that you didn’t have to type the closing
parenthesis. When you press the Enter key, the closing parenthesis is inserted automati-
cally. The value 4,967 is displayed in cell B22, indicating that the total expenses for January
Amanda wants to know how much money is left over at the end of each month or, in
other words, the family’s net income each month. To determine this amount, you need to
enter a formula that subtracts the total monthly expenses from the total monthly income.
You’ll begin by calculating the net income for the month of January.