Microsoft Office Tutorials and References

In Depth Information

Working with the Total row

The Total row is an optional table element that contains formulas that summarize the information in the

columns. Normally, the Total row isn't displayed. To display the Total row, choose Table Tools
⇒
Design
⇒
Table

Style Options
⇒
Total Row. This command is a toggle that turns the Total row on and off.

By default, the Total row displays the sum of the values in a column of numbers. In many cases, you'll want a

different type of summary formula. When you select a cell in the Total row, a drop-down arrow appears, and

you can select from a number of other summary formulas (see Figure 9-11):

•
None:
No formula.

•
Average:
Displays the average of the numbers in the column.

•
Count:
Displays the number of entries in the column. (Blank cells are not counted.)

•
Count Numbers:
Displays the number of numeric values in the column. (Blank cells, text cells, and error

cells are not counted.)

•
Max:
Displays the maximum value in the column.

•
Min:
Displays the minimum value in the column.

•
Sum:
Displays the sum of the values in the column.

•
StdDev:
Displays the standard deviation of the values in the column.
Standard deviation
is a statistical

measure of how “spread out” the values are.

•
Var:
Displays the variance of the values in the column. Variance is another statistical measure of how

“spread out” the values are.

•
More Functions:
Displays the Insert Function dialog box so that you can select a function that isn't in the

list.