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.
Search JabSto ::




Custom Search