Database functions
Database functions total, count and average rows of a table that match a criteria block. They predate SUMIFS and FILTER but still show up in older workbooks.
12 functions in this category.
Start here
- DAVERAGE
Averages one column across the rows that satisfy your criteria; like AVERAGEIFS with a criteria block.
- DSUM
Adds up a column for rows meeting your criteria; an older cousin of SUMIFS.
- DCOUNT
Counts how many matching rows hold a number in the chosen column.
- DCOUNTA
Counts non-blank cells in the chosen column for matching rows.
- DGET
Pulls one single value from the list for the one row matching the criteria.
- DMAX
Finds the largest value in a column among the matching rows.
All database functions
| Function | What it does | Level | Since | Spills? |
|---|---|---|---|---|
DAVERAGE | Averages one column across the rows that satisfy your criteria; like AVERAGEIFS with a criteria block. | Expert | 2007 or earlier | No |
DCOUNT | Counts how many matching rows hold a number in the chosen column. | Expert | 2007 or earlier | No |
DCOUNTA | Counts non-blank cells in the chosen column for matching rows. | Expert | 2007 or earlier | No |
DGET | Pulls one single value from the list for the one row matching the criteria. | Expert | 2007 or earlier | No |
DMAX | Finds the largest value in a column among the matching rows. | Expert | 2007 or earlier | No |
DMIN | Finds the smallest value in a column among the matching rows. | Expert | 2007 or earlier | No |
DPRODUCT | Multiplies together the values in a column for matching rows. | Expert | 2007 or earlier | No |
DSTDEV | Estimates standard deviation from matching rows treated as a sample. | Expert | 2007 or earlier | No |
DSTDEVP | Standard deviation of matching rows treated as the whole population. | Expert | 2007 or earlier | No |
DSUM | Adds up a column for rows meeting your criteria; an older cousin of SUMIFS. | Intermediate | 2007 or earlier | No |
DVAR | Sample variance of the matching rows in a column. | Expert | 2007 or earlier | No |
DVARP | Population variance of the matching rows in a column. | Expert | 2007 or earlier | No |
Other categories
- Lookup and reference functions
43 functions
- Math and trig functions
80 functions
- Logical functions
19 functions
- Text functions
48 functions
- Date and time functions
25 functions
- Statistical functions
111 functions
- Financial functions
56 functions
- Information functions
21 functions
- Engineering functions
54 functions
- Web functions
3 functions
- Compatibility functions
41 functions
- Cube functions
7 functions
- Add-in and automation functions
5 functions