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