# database functions

Group, aggregate and query tabular ranges.

15 functions.

- [DAVERAGE](https://deepcalc.com/docs/functions/daverage.md): average of database values matching criteria
- [DCOUNT](https://deepcalc.com/docs/functions/dcount.md): counts numeric database values matching criteria
- [DCOUNTA](https://deepcalc.com/docs/functions/dcounta.md): counts non-empty database values matching criteria
- [DGET](https://deepcalc.com/docs/functions/dget.md): the single database value matching criteria
- [DMAX](https://deepcalc.com/docs/functions/dmax.md): largest database value matching criteria
- [DMIN](https://deepcalc.com/docs/functions/dmin.md): smallest database value matching criteria
- [DPRODUCT](https://deepcalc.com/docs/functions/dproduct.md): product of database values matching criteria
- [DSTDEV](https://deepcalc.com/docs/functions/dstdev.md): sample standard deviation of matching database values
- [DSTDEVP](https://deepcalc.com/docs/functions/dstdevp.md): population standard deviation of matching database values
- [DSUM](https://deepcalc.com/docs/functions/dsum.md): sum of database values matching criteria
- [DVAR](https://deepcalc.com/docs/functions/dvar.md): sample variance of matching database values
- [DVARP](https://deepcalc.com/docs/functions/dvarp.md): population variance of matching database values
- [GROUPBY](https://deepcalc.com/docs/functions/groupby.md): groups rows by a field and aggregates values: excel's argument list; `function` is SUM, COUNT, AVERAGE, MAX, MIN or PRODUCT, written as in excel (SUM), as text or as a selector; a LAMBDA is refused
- [PIVOTBY](https://deepcalc.com/docs/functions/pivotby.md): groups rows and columns and aggregates the values: excel's argument list; `function` is SUM, COUNT, AVERAGE, MAX, MIN or PRODUCT, written as in excel (SUM), as text or as a selector; a LAMBDA is refused
- [TABLEJOIN](https://deepcalc.com/docs/functions/tablejoin.md): inner-joins two ranges on a key column in each

## navigate

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

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