Excel Database Formulas Reference

On April 18, 2010, in Excel, Software, by Layne

Here is a listing of database functions to add to our collection of the formulas reference.
You will find the following information for each function:

Function name; and
Function definition.

NOTE: In the description you will find the function syntax and a description of each argument. Arguments that appear in bold text are required; arguments that do not appear in bold text are option.

This list was compiled using several resources to give you the most complete information to put them to use, without over-complicating them.

Function	Description
DAVERAGE	Averages the values in a column in a list or database that match conditions you specify and takes the form =DAVERAGE(database,field,criteria), where database is the range of cells that make up the list or database and the first row of the list contains labels for each column; field indicates which column is used in the function (by label name or by position); and criteria is the range of cells that contains the conditions you specify.
DCOUNT	Counts the cells that contain numbers in a column in a list or database that match conditions you specify and takes the form =DCOUNT(database,field,criteria); where database is the range of cells that make up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DCOUNTA	Same as DCOUNT, except that it also includes cells containing text, logical values, and error values
DGET	Extracts a singular value from a column in a list or database that matches conditions you specify and takes the form =DGET(database,field,criteria), where database is the range of cells that make up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DMAX	Returns the largest number in a column in a list or database that matches conditions you specify and takes the form =DMAX(database,field,criteria), where database is a range that makes up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DMIN	Returns the smallest number in a column in a list or database that matches conditions you specify and takes the same for and arguments as DMAX.
DPRODUCT	Multiplies the values in a list or database that match conditions you specify and takes the form =DPRODUCT(database,field,criteria), where database is a range that makes up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DSTDEV	Estimates the standard deviation of a population based on a sample, using the numbers in a column in a list or database that match conditions you specify, and takes the same form and arguments as DPRODUCT.
DSTDEVP	Calculates the standard deviation of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify, and takes the same form and arguments as DPRODUCT.
DSUM	Adds the numbers in a column in a list or database that match conditions you specify and takes the same for and arguments as DPRODUCT.
DVAR	Estimates the variance of a population based on a sample, using the numbers in a column in a list or database that match conditions you specify, and takes the form =DVAR(database,field,criteria), where database is the range of cells that make up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DVARP	Calculates the variance of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify, and takes the same form as DVAR.

<!–[if gte mso 10]>

Function	Description
DAVERAGE	Averages the values in a column in a list or database that match conditions you specify and takes the form =DAVERAGE(database,field,criteria), where database is the range of cells that make up the list or database and the first row of the list contains labels for each column; field indicates which column is used in the function (by label name or by position); and criteria is the range of cells that contains the conditions you specify.
DCOUNT	Counts the cells that contain numbers in a column in a list or database that match conditions you specify and takes the form =DCOUNT(database,field,criteria); where database is the range of cells that make up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DCOUNTA	Same as DCOUNT, except that it also includes cells containing text, logical values, and error values
DGET	Extracts a singular value from a column in a list or database that matches conditions you specify and takes the form =DGET(database,field,criteria), where database is the range of cells that make up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DMAX	Returns the largest number in a column in a list or database that matches conditions you specify and takes the form =DMAX(database,field,criteria), where database is a range that makes up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DMIN	Returns the smallest number in a column in a list or database that matches conditions you specify and takes the same for and arguments as DMAX.
DPRODUCT	Multiplies the values in a list or database that match conditions you specify and takes the form =DPRODUCT(database,field,criteria), where database is a range that makes up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DSTDEV	Estimates the standard deviation of a population based on a sample, using the numbers in a column in a list or database that match conditions you specify, and takes the same form and arguments as DPRODUCT.
DSTDEVP	Calculates the standard deviation of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify, and takes the same form and arguments as DPRODUCT.
DSUM	Adds the numbers in a column in a list or database that match conditions you specify and takes the same for and arguments as DPRODUCT.
DVAR	Estimates the variance of a population based on a sample, using the numbers in a column in a list or database that match conditions you specify, and takes the form =DVAR(database,field,criteria), where database is the range of cells that make up the list or database; field indicates which column is used in the function; and criteria is the range of cells that contains the conditions you specify.
DVARP	Calculates the variance of a population based on the entire population, using the numbers in a column in a list or database that match conditions you specify, and takes the same form as DVAR.

Tagged with: Microsoft Excel

Administrative Sparkle

A place for administrative professionals to escape and become inspired.