Microsoft Office Tutorials and References

In Depth Information

**Using the Fill Handle to Copy a Cell to Adjacent Cells**

3

•
Click the Enter box in

the formula bar to

enter the sum of the

ﬁ rst quarter sales for

the ﬁ ve product types

for the Northeast

region in cell B9

(Figure 1-34).

What is the purpose

of the Sum button

arrow?

If you click the Sum

button arrow on the

right side of the Sum

button (Figure 1–34),

Excel displays a list

of often-used func-

tions from which you

can choose. The list

includes functions that

allow you to deter-

mine the average, the

number of items in

the selected range, the

minimum value, or the

maximum value of a

range of numbers.

SUM function

assigned to active

cell B9 shows in

formula bar

Sum

button

arrow

sum of numbers

in cells B4, B5,

B6, B7, and B8

Figure 1–34

Other Ways

1. Click Insert Function

button in formula bar,

select SUM in Select a

function list, click OK

button, select range,

click OK button

2. Click Sum button arrow

on Ribbon, click More

Functions, select SUM

in Select a function list,

click OK button, select

range, click OK button

3. Type = s in cell,

select SUM from list,

select range

4. Press ALT
+
EQUAL

SIGN (=) twice

Adjacent Cells

Excel also must calculate the totals for the Southeast in cell C9, the Midwest in cell D9,

the South in cell E9, and for the West in cell F9. Table 1–2 illustrates the similarities

between the entry in cell B9 and the entries required to sum the totals in cells C9, D9, E9,

and F9.

Table 1–2 Sum Function Entries in Row 9

Cell

Sum Function Entries

Remark

B9

=SUM(B4:B8)

Sums cells B4, B5, B6, B7, and B8

C9

=SUM(C4:C8)

Sums cells C4, C5, C6, C7, and C8

D9

=SUM(D4:D8)

Sums cells D4, D5, D6, D7, and D8

E9

=SUM(E4:E8)

Sums cells E4, E5, E6, E7, and E8

F9

=SUM(F4:F8)

Sums cells F4, F5, F6, F7, and F8