Excel database functions
Database functions in Excel, explained with live examples.
12 database functions in Excel — 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 selected database entriesDatabaseGoogle Sheets
- DCOUNTCounts the cells that contain numbers in a databaseDatabaseGoogle Sheets
- DCOUNTACounts nonblank cells in a databaseDatabaseGoogle Sheets
- DGETExtracts from a database a single record that matches the specified criteriaDatabaseGoogle Sheets
- DMAXReturns the maximum value from selected database entriesDatabaseGoogle Sheets
- DMINReturns the minimum value from selected database entriesDatabaseGoogle Sheets
- DPRODUCTMultiplies the values in a particular field of records that match the criteria in a databaseDatabaseGoogle Sheets
- DSTDEVEstimates the standard deviation based on a sample of selected database entriesDatabaseGoogle Sheets
- DSTDEVPCalculates the standard deviation based on the entire population of selected database entriesDatabaseGoogle Sheets
- DSUMAdds the numbers in the field column of records in the database that match the criteriaDatabaseGoogle Sheets
- DVAREstimates variance based on a sample from selected database entriesDatabaseGoogle Sheets
- DVARPCalculates variance based on the entire population of selected database entriesDatabaseGoogle Sheets
More Excel function categories