SpreadCE Help

Database functions

[ ] indicates optional parameters

DAVERAGE(database_range, field, criteria_range)
DCOUNT(database_range, [field], criteria_range)
DCOUNTA(database_range, [field], criteria_range)
DGET(database_range, field, criteria_range)
DMAX(database_range, field, criteria_range)
DMIN(database_range, field, criteria_range)
DPRODUCT(database_range, field, criteria_range)
DSTDEV(database_range, field, criteria_range)
DSTDEVP(database_range, field, criteria_range)
DSUM(database_range, field, criteria_range)
DVAR(database_range, field, criteria_range)
DVARP(database_range, field, criteria_range)

Database functions

DAVERAGE(database_range, field, criteria_range)

Returns the average of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the average.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DCOUNT(database_range, [field], criteria_range)

Returns the count of the number of rows in the database that meet the selection criteria and where the specified field contains a number.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values that you want to count. If this parameter is omitted then the function will return the number of database rows that meet the selection criteria.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DCOUNTA(database_range, [field], criteria_range)

Returns the count of the number of rows in the database that meet the selection criteria and where the specified field is not blank.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values that you want to count. If this parameter is omitted then the function will return the number of database rows that meet the selection criteria.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DGET(database_range, field, criteria_range)

Returns the value of a specified field from the row in the database range that meets the selection criteria. There should be one and only one row that meets the selection criteria. If no rows meet the criteria then the error #VALUE! is returned. If more than one row meets the criteria then the error #NUM! is returned.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the value that you want to retrieve.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DMAX(database_range, field, criteria_range)

Returns the maximum of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the maximum.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DMIN(database_range, field, criteria_range)

Returns the minimum of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the minimum.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DPRODUCT(database_range, field, criteria_range)

Returns the product of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values that you want to multiply together.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DSTDEV(database_range, field, criteria_range)

Returns the standard deviation (based on a population sample) of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the standard deviation.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DSTDEVP(database_range, field, criteria_range)

Returns the standard deviation (based on the entire population) of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the standard deviation.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DSUM(database_range, field, criteria_range)

Returns the sum of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the sum.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DVAR(database_range, field, criteria_range)

Returns the variance (based on a population sample) of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the variance.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.

DVARP(database_range, field, criteria_range)

Returns the variance (based on the entire population) of the values of a specified field in a database range.

database_range | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
field | The column number or column heading name of the values of which you want to find the variance.
criteria_range | A reference to cells that contain the criteria that you want to use when selecting records from the database to process. You can specify the same range as used for the database_range parameter if you want to select all the rows.