Microsoft Office Tutorials and References
In Depth Information
To Use the Total Row Check Box
2
Click the Total Row
check box on the
Ribbon to add the
total row and display
the record count in
the far-right
column of the
table, column J.
Total Row
check box
selected
Select cell H22.
When Excel displays
an arrow on the right
side of the cell, click
the arrow to display
a list of available
statistical functions
(Figure 5–30).
YTD Sales
Total row
arrow
YTD Sales
cell in
Total row
active
list of available
statistical
functions for YTD
Sales Total cell
Sum
function
Figure 5–30
3
Click Sum in the list.
Select cell G22, click
the arrow on the
right side of the cell,
and then click Sum in
the list.
Select cell C22, click
the arrow on the
right side of the
cell, and then click
Average in the list.
Select cell A9
(Figure 5–31).
sum of
Quota
values
sum of
YTD Sales
values
record
counts of
values in
Grade column
average of
values in
Age column
Figure 5–31
 
Search JabSto ::




Custom Search