AVG |
Single value in a new column for the ALL keyword;
one column with a single value for each input column for the COL keyword;
one column with a value for each row for the ROW keyword. |
Computes the arithmetic mean or average of a range of cells |
COUNT |
Single value in a new column. |
Counts the number of values in a specified data range |
MAX |
Single value in a new column for the ALL keyword;
one column with a single value for each input column for the COL keyword;
one column with a value for each row for the ROW keyword. |
Computes the maximum of a range of cells |
MEAN |
Single value in a new column for the ALL keyword;
one column with a single value for each input column for the COL keyword;
one column with a value for each row for the ROW keyword. |
Computes the arithmetic mean or average of a range of cells |
MIN |
Single value in a new column for the ALL keyword;
one column with a single value for each input column for the COL keyword;
one column with a value for each row for the ROW keyword. |
Computes the minimum of a range of cells |
STDV or STDEV |
Single value in a new column for the ALL keyword;
one column with a single value for each input column for the COL keyword;
one column with a value for each row for the ROW keyword. |
Computes the standard deviation of a range of cells |
VARIANCE |
Single value in a new column for the ALL keyword;
one column with a single value for each input column for the COL keyword;
one column with a value for each row for the ROW keyword. |
Computes the variance of a range of cells |