Microsoft Office Tutorials and References

In Depth Information

**Session 2.1**

To calculate the total income and expenses for January using the

SUM function:

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

Figure 2-3

the formula appears

in the Formula bar

range of

adjacent cells

selected

ScreenTip

displays

syntax for the

SUM function

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

are $4,967.

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.