# Statistical

> AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MAXA, MIN and MINA for table cell formulas in TXTextControl, with the limitations of the counting functions.

- **Product:** TX Text Control ActiveX
- **Section:** Documentation
- **Kind:** Topic
- **Path:** TX Text Control ActiveX > API Reference > Supported Formula Functions > Statistical
- **513 words**
- **Web URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/statistical/
- **LLMs URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/statistical/llms.txt
- **LLMs-Full URL:** https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/statistical/llms-full.txt

---

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

### Related Pages

- [Using Formulas in Table Cells](https://docs.textcontrol.com/tx-text-control-activex/document-editor/tables/formulas/llms-full.txt): calculate cell text with formulas.
- [Tables](https://docs.textcontrol.com/tx-text-control-activex/reference/categories/tables/llms-full.txt): `TableCellFormula` and the other members for tables and cells.
- [Mathematical and Trigonometric](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/mathematical-trigonometric/llms-full.txt): arithmetic, rounding, logarithms, trigonometry and sums.
- [Logical](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/logical/llms-full.txt): AND, OR, NOT, IF, TRUE and FALSE.
- [Lookup and Reference](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/lookup-reference/llms-full.txt): cell addresses, rows, columns and choosing from a list.
- [Information](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/information/llms-full.txt): test the type and content of values and cells.

---

## Nearby

- **Previous:** [Mathematical and Trigonometric](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/mathematical-trigonometric/llms-full.txt)
- **Next:** [Logical](https://docs.textcontrol.com/tx-text-control-activex/reference/formula-functions/logical/llms-full.txt)