Functions Database Copy page Copy as markdownThe page as text, ready for a chat View as markdown/docs/functions/database-functions.md Ask Claude about this pageOpens Claude with this page's address Group, aggregate and query tabular ranges. FunctionWhat it does DAVERAGE Average of database values matching criteria. DCOUNT Counts numeric database values matching criteria. DCOUNTA Counts non-empty database values matching criteria. DGET The single database value matching criteria. DMAX Largest database value matching criteria. DMIN Smallest database value matching criteria. DPRODUCT Product of database values matching criteria. DSTDEV Sample standard deviation of matching database values. DSTDEVP Population standard deviation of matching database values. DSUM Sum of database values matching criteria. DVAR Sample variance of matching database values. DVARP Population variance of matching database values. GROUPBY 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 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 Inner-joins two ranges on a key column in each.
