Database Functions
- 2 minutes to read
This document describes database functions supported by the WPF Spreadsheet control.
Database functions use cell ranges that make up a list or database. A database in this context is a list of related data in which rows are records and columns are fields. The first row of the list contains labels for each column.
A database (or list) is defined by the datalist parameter in the function syntax.
| Name | Description | Syntax |
|---|---|---|
| DAVERAGE | Returns the average of selected database entries. | DAVERAGE(datalist, field, criteria) |
| DCOUNT | Counts the cells that contain numbers in a database. | DCOUNT(datalist, field, criteria) |
| DCOUNTA | Counts nonblank cells in a database. | DCOUNTA(datalist, field, criteria) |
| DGET | Extracts from a database a single record that matches the specified criteria. | DGET(datalist, field, criteria) |
| DMAX | Returns the maximum value from selected database entries. | DMAX(datalist, field, criteria) |
| DMIN | Returns the minimum value from selected database entries. | DMIN(datalist, field, criteria) |
| DPRODUCT | Multiplies the values in a particular field of records that match the criteria in a database. | DPRODUCT(datalist, field, criteria) |
| DSTDEV | Estimates the standard deviation based on a sample of selected database entries. | DSTDEV(datalist, field, criteria) |
| DSTDEVP | Calculates the standard deviation based on the entire population of selected database entries. | DSTDEVP(datalist, field, criteria) |
| DSUM | Adds the numbers in the field column of records in the database that match the criteria. | DSUM(datalist, field, criteria) |
| DVAR | Estimates variance based on a sample from selected database entries. | DVAR(datalist, field, criteria) |
| DVARP | Calculates variance based on the entire population of selected database entries. | DVARP(datalist, field, criteria) |
See Also