Google Sheets database functions
Database functions in Google Sheets, explained with live examples.
12 database functions in Google Sheets — 0 documented in depth so far, the rest indexed below and landing every week.
All Google Sheets database functions
The full set — deep dives on the way.
- DAVERAGE
- Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.
- DCOUNT
- Counts numeric values selected from a database table-like array or range using a SQL-like query.
- DCOUNTA
- Counts values, including text, selected from a database table-like array or range using a SQL-like query.
- DGET
- Returns a single value from a database table-like array or range using a SQL-like query.
- DMAX
- Returns the maximum value selected from a database table-like array or range using a SQL-like query.
- DMIN
- Returns the minimum value selected from a database table-like array or range using a SQL-like query.
- DPRODUCT
- Returns the product of values selected from a database table-like array or range using a SQL-like query.
- DSTDEV
- Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.
- DSTDEVP
- Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.
- DSUM
- Returns the sum of values selected from a database table-like array or range using a SQL-like query.
- DVAR
- Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.
- DVARP
- Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.
More Google Sheets function categories