# database functions

group, aggregate and query tabular ranges.

15 functions.

- [DAVERAGE](https://deepcalc.com/functions/daverage.md) — average of database values matching criteria
- [DCOUNT](https://deepcalc.com/functions/dcount.md) — counts numeric database values matching criteria
- [DCOUNTA](https://deepcalc.com/functions/dcounta.md) — counts non-empty database values matching criteria
- [DGET](https://deepcalc.com/functions/dget.md) — the single database value matching criteria
- [DMAX](https://deepcalc.com/functions/dmax.md) — largest database value matching criteria
- [DMIN](https://deepcalc.com/functions/dmin.md) — smallest database value matching criteria
- [DPRODUCT](https://deepcalc.com/functions/dproduct.md) — product of database values matching criteria
- [DSTDEV](https://deepcalc.com/functions/dstdev.md) — sample standard deviation of matching database values
- [DSTDEVP](https://deepcalc.com/functions/dstdevp.md) — population standard deviation of matching database values
- [DSUM](https://deepcalc.com/functions/dsum.md) — sum of database values matching criteria
- [DVAR](https://deepcalc.com/functions/dvar.md) — sample variance of matching database values
- [DVARP](https://deepcalc.com/functions/dvarp.md) — population variance of matching database values
- [GROUPBY](https://deepcalc.com/functions/groupby.md) — groups rows by a label column and aggregates a value column
- [PIVOTBY](https://deepcalc.com/functions/pivotby.md) — groups rows and columns and aggregates the values
- [TABLEJOIN](https://deepcalc.com/functions/tablejoin.md) — inner-joins two ranges on a key column in each

## navigate

- [function index](https://deepcalc.com/functions.md)
- [error values](https://deepcalc.com/errors.md) · [concepts](https://deepcalc.com/concepts.md) · [limits](https://deepcalc.com/limits.md)

source: https://deepcalc.com/functions/database-functions