Database Excel Functions
Query data that matches criteria
D-functions vs SUMIFS
- Sum with criteria table → [DSUM](/functions/dsum/)
- Average → [DAVERAGE](/functions/daverage/)
- Count numbers → [DCOUNT](/functions/dcount/)
- Modern alternative → [SUMIFS](/functions/sumifs/) and [COUNTIFS](/functions/countifs/)
- Compare → [SUMIF vs SUMIFS](/compare/sumif-vs-sumifs/)
Criteria range tips
- Headers must match the database column names exactly
- Same row = AND; extra rows = OR between criteria sets
- Wildcards * and ? work in text criteria
Functions in this category
- DSUM: Adds the numbers in a field of records in a database that match criteria.
- DAVERAGE: Returns the average of selected database entries that match specified criteria.
- DCOUNT: Counts cells containing numbers in a database that match specified criteria.
- DCOUNTA: Counts non-blank cells in a database that match specified criteria.
- DGET: Extracts a single value from a database that matches specified criteria.
- DMAX: Returns the maximum value from database entries that match specified criteria.
- DMIN: Returns the minimum value from database entries that match specified criteria.
- DPRODUCT: Multiplies values in a database field that match specified criteria.
- DSTDEV: Estimates standard deviation based on a sample from database entries matching criteria.
- DSTDEVP: Calculates standard deviation based on entire population from database entries matching criteria.
- DVAR: Estimates variance based on a sample from database entries matching criteria.
- DVARP: Calculates variance based on entire population from database entries matching criteria.