Database
- DAVERAGE — average of the values in field in database belonging to records that match criteria
- DCOUNT — count of numbers in field in database belonging to records that match criteria
- DCOUNTA — count of cells with data in field in database belonging to records that match criteria
- DGET — a value from field in database belonging to records that match criteria
- DMAX — largest number in field in database belonging to a record that match criteria
- DMIN — smallest number in field in database belonging to a record that match criteria
- DPRODUCT — product of all values in field in database belonging to records that match criteria
- DSTDEV — sample standard deviation of the values in field in database belonging to records that match criteria
- DSTDEVP — standard deviation of the population of values in field in database belonging to records that match criteria
- DSUM — sum of the values in field in database belonging to records that match criteria
- DVAR — sample variance of the values in field in database belonging to records that match criteria
- DVARP — variance of the population of values in field in database belonging to records that match criteria
- GETPIVOTDATA — summary data from a pivot table
DAVERAGE
Synopsis
DAVERAGE(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DCOUNT
Synopsis
DCOUNT(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
DCOUNTA
Synopsis
DCOUNTA(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DGET
Synopsis
DGET(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
Note
If none of the records match the conditions, DGET returns #VALUE! If more than one record match the conditions, DGET returns #NUM!
See also
DMAX
Synopsis
DMAX(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DMIN.
DMIN
Synopsis
DMIN(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DPRODUCT
Synopsis
DPRODUCT(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DSUM.
DSTDEV
Synopsis
DSTDEV(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DSTDEVP
Synopsis
DSTDEVP(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DSUM
Synopsis
DSUM(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DVAR
Synopsis
DVAR(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DVARP
Synopsis
DVARP(database,field,criteria)
Arguments
database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
Description
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.
See also
DVAR.
GETPIVOTDATA
Synopsis
GETPIVOTDATA(pivot_table,field_name)
Arguments
pivot_table: cell range containing the pivot table
field_name: name of the field for which the summary data is requested
Note
If the summary data is unavailable, GETPIVOTDATA returns #REF!