Practice free

Database functions

Database functions total, count and average rows of a table that match a criteria block. They predate SUMIFS and FILTER but still show up in older workbooks.

12 functions in this category.

Start here

All database functions

FunctionWhat it doesLevelSinceSpills?
DAVERAGE Averages one column across the rows that satisfy your criteria; like AVERAGEIFS with a criteria block. Expert 2007 or earlier No
DCOUNT Counts how many matching rows hold a number in the chosen column. Expert 2007 or earlier No
DCOUNTA Counts non-blank cells in the chosen column for matching rows. Expert 2007 or earlier No
DGET Pulls one single value from the list for the one row matching the criteria. Expert 2007 or earlier No
DMAX Finds the largest value in a column among the matching rows. Expert 2007 or earlier No
DMIN Finds the smallest value in a column among the matching rows. Expert 2007 or earlier No
DPRODUCT Multiplies together the values in a column for matching rows. Expert 2007 or earlier No
DSTDEV Estimates standard deviation from matching rows treated as a sample. Expert 2007 or earlier No
DSTDEVP Standard deviation of matching rows treated as the whole population. Expert 2007 or earlier No
DSUM Adds up a column for rows meeting your criteria; an older cousin of SUMIFS. Intermediate 2007 or earlier No
DVAR Sample variance of the matching rows in a column. Expert 2007 or earlier No
DVARP Population variance of the matching rows in a column. Expert 2007 or earlier No

Other categories