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
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

Search JabSto ::

Custom Search