Programmming 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. |