Fonctions Base de données

[ ] indicates optional parameters

BDECARTYPE(base_de_données; champ; critères)
BDECARTYPEP(base_de_données; champ; critères)
BDLIRE(base_de_données; champ; critères)
BDMAX(base_de_données; champ; critères)
BDMIN(base_de_données; champ; critères)
BDMOYENNE(base_de_données; champ; critères)
BDNB(base_de_données; [champ]; critères)
BDNBVAL(base_de_données; [champ]; critères)
BDPRODUIT(base_de_données; champ; critères)
BDSOMME(base_de_données; champ; critères)
BDVAR(base_de_données; champ; critères)
BDVARP(base_de_données; champ; critères)


Fonctions Base de données

BDECARTYPE(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the standard deviation.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDECARTYPEP(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the standard deviation.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDLIRE(base_de_données; champ; critères)

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.

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the value that you want to retrieve.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDMAX(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the maximum.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDMIN(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the minimum.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDMOYENNE(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the average.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDNB(base_de_données; [champ]; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe 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.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDNBVAL(base_de_données; [champ]; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe 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.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDPRODUIT(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values that you want to multiply together.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDSOMME(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the sum.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDVAR(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the variance.
critèresA 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 base_de_données parameter if you want to select all the rows.


BDVARP(base_de_données; champ; critères)

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

base_de_donnéesA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
champThe column number or column heading name of the values of which you want to find the variance.
critèresA 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 base_de_données parameter if you want to select all the rows.