This reference lists 12 Excel database functions, ordered by frequency of use, with high-frequency functions marked ⭐. Each function includes its syntax and an example.
| Function | Description | Example |
|---|---|---|
DAVERAGE |
Returns the average of selected database entries | =DAVERAGE(A1:E10,"Grade",A1:B2) — Averages grades in A1:E10 that meet the criteria in A1:B2 (e.g. Class = 1) |
DCOUNT |
Counts the cells that contain numbers in a database | =DCOUNT(A1:E10,"Age",A1:B2) — Counts numeric cells in A1:E10 meeting a condition such as Age > 18 |
DCOUNTA |
Counts nonblank cells in a database | =DCOUNTA(A1:E10,"Name",A1:B2) — Counts non-empty name cells in A1:E10 that meet the condition |
DGET |
Extracts from a database a single record that matches the specified criteria | =DGET(A1:E10,"Grade",A1:B2) — Extracts a single matching grade value from A1:E10 (must match uniquely) |
DMAX |
Returns the maximum value from selected database entries | =DMAX(A1:E10,"Grade",A1:B2) — Finds the highest grade in A1:E10 where Class = 1 |
DMIN |
Returns the minimum value from selected database entries | =DMIN(A1:E10,"Grade",A1:B2) — Finds the lowest grade in A1:E10 that meets the condition |
DPRODUCT |
Multiplies the values in a particular field of records that match the criteria in a database | =DPRODUCT(A1:E10,"Quantity",A1:B2) — Multiplies the quantity values in A1:E10 where Product = A |
DSTDEV |
Estimates the standard deviation based on a sample of selected database entries | =DSTDEV(A1:E10,"Grade",A1:B2) — Returns the sample standard deviation of matching rows (a subset of the data) |
DSTDEVP |
Calculates the standard deviation based on the entire population of selected database entries | =DSTDEVP(A1:E10,"Grade",A1:B2) — Returns the population standard deviation of all matching rows |
DSUM |
Adds the numbers in the field column of records in the database that match the criteria | =DSUM(A1:E10,"Sales",A1:B2) — Sums sales in A1:E10 where Region = Beijing |
DVAR |
Estimates variance based on a sample from selected database entries | =DVAR(A1:E10,"Grade",A1:B2) — Returns the sample variance of matching data (an estimate) |
DVARP |
Calculates variance based on the entire population of selected database entries | =DVARP(A1:E10,"Grade",A1:B2) — Returns the population variance of matching data (exact) |
From Online Toolbox (www.vba.net)