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

DAVERAGE average of the values in field in database belonging to records that match criteria

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.

DCOUNT

DCOUNT count of numbers in field in database belonging to records that match criteria

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.

See also

DAVERAGE, DCOUNTA.

DCOUNTA

DCOUNTA count of cells with data in field in database belonging to records that match criteria

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

DCOUNT.

DGET

DGET a value from field in database belonging to records that match criteria

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

DCOUNT.

DMAX

DMAX largest number in field in database belonging to a record that match criteria

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

DMIN smallest number in field in database belonging to a record that match criteria

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

DCOUNT.

DPRODUCT

DPRODUCT product of all values in field in database belonging to records that match criteria

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

DSTDEV sample standard deviation of the values in field in database belonging to records that match criteria

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.

DSTDEVP

DSTDEVP standard deviation of the population of values in field in database belonging to records that match criteria

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

DSTDEV.

DSUM

DSUM sum of the values in field in database belonging to records that match criteria

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

DPRODUCT.

DVAR

DVAR sample variance of the values in field in database belonging to records that match criteria

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.

DVARP

DVARP variance of the population of values in field in database belonging to records that match criteria

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

GETPIVOTDATA summary data from a pivot table

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!