Microsoft Office Tutorials and References
In Depth Information
EX 26
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
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.
SUM function
assigned to active
cell B9 shows in
formula bar
Sum
button
arrow
Select cell B9 to
display the SUM
function assigned to
cell B9 in the formula
bar (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
functions from which you
can choose. The list
includes functions that
allow you to
determine the average, the
number of items in the
selected range, the minimum value, or the maximum value of a range of numbers.
sum of numbers
in cells B4, B5,
B6, B7, and B8
Figure 1–34
Other Ways
1. Click Function Wizard
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
Using the Fill Handle to Copy a Cell to
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