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)