Reference: Workbook Quick Statistics
When you select a range of cells in a workbook, including defined names, columns, rows,
sheets, and Comments panel references, these formulas display to the right of the
formula bar to provide quick reference statistics about your selection:
- SUM
- AVERAGE
- MIN
- MAX
- COUNT
- COUNTA
Based on the types of data in the selected cells, the relevant functions are available in the
drop-down list.
The following table lists usage notes for the available functions.
Function | Notes |
|---|---|
SUM | Sum of the selected numeric cells. Units in the same dimension (such as length) are converted as needed to
determine the sum. Example: If some selected cells use the ft unit, and others
use the cm unit, the SUM function converts the
values as needed. The result displays in the units of the topmost
selected cell.SUM doesn't evaluate values in different currencies or other units it can't combine, such
as cm and liter . |
AVERAGE | Average value of the selected numeric cells. Units in the same dimension (such as length) are averaged. Example: If some selected cells use the ft unit, and others
use the cm unit, the AVERAGE function converts
the values as needed. The result displays in the units of the topmost
selected cell.AVERAGE doesn't evaluate values in different currencies or other units that it can't
combine, such as cm and
liter . |
MIN | Minimum value in the selected numeric cells. Units in the same dimension (such as length) are converted as needed to
determine the minimum value. Example: If some selected cells use the ft unit, and others use the
cm unit, the MIN function converts the values
and shows the result in the units of the topmost selected cell.MIN doesn't evaluate values in different currencies or other units that it can't combine,
such as cm and liter . |
MAX | Maximum value in the selected cells. Units in the same dimension (such as length) are converted as needed to
determine the maximum value. Example: If some selected cells use the ft unit, and others use the
cm unit, the MAX function converts the values
and shows the result in the units of the topmost selected cell.MAX doesn't evaluate values in different currencies or other units that it can't combine,
such as cm and liter . |
COUNT | Count of selected numeric cells. |
COUNTA | Count of all selected cells containing data. When all cells in the selection contain non-numeric data, then COUNTA is
the only available statistic. |