Returns the average of selected database entries.
|
DAVERAGE(datalist, field, criteria)
|
DCOUNT
|
|
Counts the cells that contain numbers in a database.
|
DCOUNT(datalist, field, criteria)
|
DCOUNTA
|
|
Counts nonblank cells in a database.
|
DCOUNTA(datalist, field, criteria)
|
DGET
|
|
Extracts from a database a single record that matches the specified criteria.
|
DGET(datalist, field, criteria)
|
DMAX
|
|
Returns the maximum value from selected database entries.
|
DMAX(datalist, field, criteria)
|
DMIN
|
|
Returns the minimum value from selected database entries.
|
DMIN(datalist, field, criteria)
|
DPRODUCT
|
|
Multiplies the values in a particular field of records that match the criteria in a database.
|
DPRODUCT(datalist, field, criteria)
|
DSTDEV
|
|
Estimates the standard deviation based on a sample of selected database entries.
|
DSTDEV(datalist, field, criteria)
|
DSTDEVP
|
|
Calculates the standard deviation based on the entire population of selected database entries.
|
DSTDEVP(datalist, field, criteria)
|
DSUM
|
|
Adds the numbers in the field column of records in the database that match the criteria.
|
DSUM(datalist, field, criteria)
|
DVAR
|
|
Estimates variance based on a sample from selected database entries.
|
DVAR(datalist, field, criteria)
|
DVARP
|
|
Calculates variance based on the entire population of selected database entries.
|
DVARP(datalist, field, criteria)
|
|