Statistical
Statistical functions in a table cell formula of TXTextControl compute the average, the largest and the smallest value of a set of numbers and count cells and arguments. Where a function has limitations in TX Text Control, they are given with the function.
Argument types, restrictions and return values of each function are defined in Office Open XML File Formats, ISO/IEC 29500-1, chapter 18.17.7 Predefined Function Definitions.
Statistical Functions
| Function | 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. (Limitation: 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. (Limitation: 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. (Limitation: Cells 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. |