Type in Google’s function list
Database functions
Functions that summarise values in a range using a criteria table. Google prints 12 Database function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| DAVERAGE | DAVERAGE(database, field, criteria) | Returns the average of a set of values selected from a database table-like array or range using a SQL-like query. |
| DCOUNT | DCOUNT(database, field, criteria) | Counts numeric values selected from a database table-like array or range using a SQL-like query. |
| DCOUNTA | DCOUNTA(database, field, criteria) | Counts values, including text, selected from a database table-like array or range using a SQL-like query. |
| DGET | DGET(database, field, criteria) | Returns a single value from a database table-like array or range using a SQL-like query. |
| DMAX | DMAX(database, field, criteria) | Returns the maximum value selected from a database table-like array or range using a SQL-like query. |
| DMIN | DMIN(database, field, criteria) | Returns the minimum value selected from a database table-like array or range using a SQL-like query. |
| DPRODUCT | DPRODUCT(database, field, criteria) | Returns the product of values selected from a database table-like array or range using a SQL-like query. |
| DSTDEV | DSTDEV(database, field, criteria) | Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query. |
| DSTDEVP | DSTDEVP(database, field, criteria) | Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query. |
| DSUM | DSUM(database, field, criteria) | Returns the sum of values selected from a database table-like array or range using a SQL-like query. |
| DVAR | DVAR(database, field, criteria) | Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query. |
| DVARP | DVARP(database, field, criteria) | Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.