Statistical

Class Library Overview > Supported Formula Functions

For further informations about argument types, restrictions and return values please see Office Open XML File Formats - ISO/IEC 29500 - 1, Chapter: 18.17.7 Predefined Function Definitions.

Formula Description
AVERAGE(argument-list) Computes the arithmetic mean of the numeric values of its arguments.
COUNT(argument-list) Counts the number of arguments in argument-list that contain numbers, and the number of cells referred to by arguments in argument-list, which contain numbers. (Limitations: Dates are not counted.)
COUNTA(argument-list) Counts the number of arguments that are not cell references, and the number of cells, referred to by arguments, which are not empty. (Limitations: Dates in arrays and cell reference values are not counted.)
COUNTBLANK ( cell-range ) Counts the number of cells in a specified range of cells, which are empty. (Limitations: Cell containing a formula that returns an empty string are not counted.)
MAX(argument-list) Computes the largest of a set of numbers.
MAXA(argument-list) Computes the largest of a set of numbers.
MIN(argument-list) Computes the smallest of a set of numbers.
MINA(argument-list) Computes the smallest of a set of numbers.