Database Functions
Functions for working with database-like data
DAVERAGE Function
The DAVERAGE function calculates the average of values in a specified field from a database range that meet criteria defined in a separate criteria range. Perfect for conditional averaging in tabular data structures.
Learn MoreDCOUNT Function
The Excel DCOUNT function counts numeric values in a specified field of a database that match given criteria. It's designed for database-style operations where data is organized with column headers, enabling conditional counting of records containing numbers only.
Learn MoreDGET Function
The Excel DGET function extracts a single value from a database table based on exact matching criteria. Unlike lookup functions, DGET requires exactly one matching record and returns specific errors when no matches or multiple matches are found, making it ideal for precise data retrieval from structured lists.
Learn MoreDMAX Function
The DMAX function returns the maximum value from a specified field in a database range that meets your defined criteria. Perfect for extracting peak values from filtered datasets without complex array formulas.
Learn MoreDMIN Function
The DMIN function finds the smallest numeric value in a specified field (column) from a database range that matches your defined criteria. Perfect for extracting minimum values from filtered datasets without pivot tables.
Learn MoreDPRODUCT Function
The DPRODUCT function multiplies numeric values from a specified field across all database records that satisfy your defined criteria. Perfect for calculating compound growth rates, total multipliers, or aggregated products from filtered datasets.
Learn MoreDSTDEV Function
The DSTDEV function calculates the estimated standard deviation for a subset of database records matching specified criteria, treating the selected data as a sample from a larger population. Perfect for analyzing variability in filtered datasets like sales performance or quality metrics.
Learn MoreDSTDEVP Function
The DSTDEVP function calculates the population standard deviation for numbers in a specified field of a database that match your defined criteria. Unlike sample standard deviation functions, DSTDEVP treats your filtered database records as the complete population for accurate statistical analysis.
Learn MoreDSUM Function
The Excel DSUM function calculates the sum of values in a specified field from a database range that meet defined criteria. It's a powerful database function designed for summarizing numeric data based on multiple conditions without needing complex array formulas.
Learn MoreDVAR Function
The DVAR function estimates the variance for a subset of database records matching specified criteria, treating the matching data as a sample from a larger population. Perfect for analyzing variability in filtered datasets.
Learn MoreDVARP Function
The Excel DVARP function calculates the population variance for values in a specified field of a database that match your defined criteria. Perfect for statistical analysis of filtered datasets representing complete populations.
Learn More