DVAR Function in Excel: Sample Variance of Matching Records
DVAR returns the sample variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →Database
Excel Database functions explained with syntax, examples and common mistakes.
📊
← Excel
Database
Excel Database functions explained with syntax, examples and common mistakes.
📄 12 articles⬇️ 6 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →DCOUNTA Function in Excel: Count Non-Empty Records Matching Criteria
DCOUNTA Function in Excel: Count Non-Empty Records Matching Criteria
DCOUNTA counts non-blank entries in a field for records that meet the criteria; unlike DCOUNT it also counts text. Like all D-functions it uses…
Read article →DVARP Function in Excel: Population Variance of Matching Records
DVARP Function in Excel: Population Variance of Matching Records
DVARP returns the population variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →DSTDEVP Function in Excel: Population SD of Matching Records
DSTDEVP Function in Excel: Population SD of Matching Records
DSTDEVP returns the population standard deviation for matching records. Like all D-functions it uses a database range and a criteria range you can edit…
Read article →DSTDEV Function in Excel: Sample SD of Matching Records
DSTDEV Function in Excel: Sample SD of Matching Records
DSTDEV returns the sample standard deviation of a field for matching records. Like all D-functions it uses a database range and a criteria range…
Read article →DPRODUCT Function in Excel: Multiply Values Matching Criteria
DPRODUCT Function in Excel: Multiply Values Matching Criteria
DPRODUCT multiplies the values of a field for matching records (rarely needed; e.g. compounding growth factors). Like all D-functions it uses a database range…
Read article →DAVERAGE Function in Excel: Average With a Criteria Table
DAVERAGE Function in Excel: Average With a Criteria Table
DatabaseLevel: ExpertAvailable in: Excel 2007+DAVERAGE averages a column for rows that meet the criteria range.Syntax=DAVERAGE(database, field.
Read article →DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT counts numeric cells in a column for matching rows. Use DCOUNTA to count any non-blank cell instead.
Read article →DSUM Function in Excel: Sum With a Criteria Table
DSUM Function in Excel: Sum With a Criteria Table
DSUM adds a column for the rows that match a criteria range on the sheet. It looks old-fashioned, but it shines when a manager…
Read article →DGET Function in Excel: Get the One Matching Value
DGET Function in Excel: Get the One Matching Value
DGET returns a single value from the row that matches — and, usefully, refuses to guess when more than one row matches.
Read article →DMIN Function in Excel: Smallest Value With a Criteria Table
DMIN Function in Excel: Smallest Value With a Criteria Table
DatabaseLevel: ExpertAvailable in: Excel 2007+DMIN is DMAX’s twin: the smallest value among matching rows.Syntax=DMIN(database, field.
Read article →DMAX Function in Excel: Largest Value With a Criteria Table
DMAX Function in Excel: Largest Value With a Criteria Table
DMAX returns the largest value in a column among matching rows. It worked in every Excel version long before MAXIFS existed.
Read article →