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(group_range, aggregate_range, function) | groups rows by a label column and aggregates a value column | 6 |
| TABLEJOIN | TABLEJOIN(left, left_key_column, right, right_key_column) | inner-joins two ranges on a key column in each | 5 |