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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the average.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe 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_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe 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_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the value that you want to retrieve.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the maximum.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the minimum.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values that you want to multiply together.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the standard deviation.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the standard deviation.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the sum.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the variance.
criteria_rangeA 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_rangeA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
fieldThe column number or column heading name of the values of which you want to find the variance.
criteria_rangeA 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.