Google Sheets database functions
Database functions in Google Sheets, explained with live examples.
12 database functions in Google Sheets — 12 documented in depth so far, the rest indexed below and landing every week.
Documented database functions
Syntax, examples, and the equivalent — ready now.
- DAVERAGEReturns the average of a set of values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DCOUNTCounts numeric values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DCOUNTACounts values, including text, selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DGETReturns a single value from a database table-like array or range using a SQL-like query.DatabaseExcel
- DMAXReturns the maximum value selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DMINReturns the minimum value selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DPRODUCTReturns the product of values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DSTDEVReturns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DSTDEVPReturns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DSUMReturns the sum of values selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DVARReturns the variance of a population sample selected from a database table-like array or range using a SQL-like query.DatabaseExcel
- DVARPReturns the variance of an entire population selected from a database table-like array or range using a SQL-like query.DatabaseExcel
More Google Sheets function categories