Microsoft Office Tutorials and References

In Depth Information

**Deleting rows or columns**

FIGURE 19.5

Several types of summary formulas are available for the Total Row.

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

■

19

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

■

If you have a formula that refers to a value in the Total Row of a table, the formula returns an error if you hide the

Total Row. But if you make the Total Row visible again, the formula works as it should.