database functions
group, aggregate and query tabular ranges.
| function | signature | what it does | tests |
|---|---|---|---|
| DAVERAGE | DAVERAGE(database, field, criteria) | average of database values matching criteria | 1 |
| DCOUNT | DCOUNT(database, field, criteria) | counts numeric database values matching criteria | 2 |
| DCOUNTA | DCOUNTA(database, field, criteria) | counts non-empty database values matching criteria | 1 |
| DGET | DGET(database, field, criteria) | the single database value matching criteria | 1 |
| DMAX | DMAX(database, field, criteria) | largest database value matching criteria | 1 |
| DMIN | DMIN(database, field, criteria) | smallest database value matching criteria | 1 |
| DPRODUCT | DPRODUCT(database, field, criteria) | product of database values matching criteria | 1 |
| DSTDEV | DSTDEV(database, field, criteria) | sample standard deviation of matching database values | 1 |
| DSTDEVP | DSTDEVP(database, field, criteria) | population standard deviation of matching database values | 1 |
| DSUM | DSUM(database, field, criteria) | sum of database values matching criteria | 1 |
| DVAR | DVAR(database, field, criteria) | sample variance of matching database values | 1 |
| DVARP | DVARP(database, field, criteria) | population variance of matching database values | 1 |
| GROUPBY | GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship]) | groups rows by a field and aggregates values — excel's argument list; `function` takes an aggregation NAME or selector, not a function reference | 6 |
| PIVOTBY | PIVOTBY(row_fields, col_fields, values, function, [field_headers], [row_total_depth], [row_sort_order], [col_total_depth], [col_sort_order], [filter_array], [relative_to]) | groups rows and columns and aggregates the values — excel's argument list; `function` takes an aggregation NAME or selector, not a function reference | — |
| TABLEJOIN | TABLEJOIN(left, left_key_column, right, right_key_column) | inner-joins two ranges on a key column in each | 5 |