Page 254 - Excel Data Analysis
P. 254
14 537547 AppB.qxd 3/4/03 11:57 AM Page 240
APPENDIXAPPENDIX
EXCEL FUNCTION QUICK REFERENCE
DATABASE FUNCTIONS
Legend
Plain courier text = required Italics = user-defined
[] = optional ...= list of items
| = or AT = Analysis ToolPak Function
FUNCTION DESCRIPTION
DAVERAGE(database, field, criteria) Averages the values in a column that match the specified criteria.
DCOUNT(database, field, criteria) Counts the numeric values in the column that match the specified
criteria.
DCOUNTA(database, field, criteria) Counts the values (both numeric and non-numeric) that match the
specified criteria.
DGET(database, field, criteria) Finds the value in the selected list that matches the specified criteria.
DMAX(database, field, criteria) Finds the maximum value in the column that matches the specified
criteria.
DMIN(database, field, criteria) Finds the minimum value in the column that matches the specified
criteria.
DPRODUCT(database, field, criteria) Multiplies the values in the column that match the specified criteria
and returns the product.
DSTDEV(database, field, criteria) Estimates the standard deviation of a sample using the numbers in the
column that match the specified criteria.
DSTDEVP(database, field, criteria) Estimates the standard deviation of the entire population using the
numbers in the column that match the specified criteria.
DSUM(database, field, criteria) Totals the numbers in the column that match the specified criteria and
returns the sum.
DVAR(database, field, criteria) Estimates the variance of a sample using the numbers in the column
that match the specified criteria.
DVARP(database, field, criteria) Estimates the variance of the entire population using the numbers in
the column that match the specified criteria.
240
240
