AVG |
One column for each input column |
Calculates the arithmetic mean or average of the cells in the
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 |
SUM |
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 sum of a range of cells |
TOTAL |
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 sum of a range of cells |