Работа с базой данных functions
[ ] indicates optional parameters
БДДИСП(база_данных, поле, критерий)БДДИСП(база_данных, поле, критерий)
Returns the variance (based on a population sample) of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the variance. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
БДДИСПП(база_данных, поле, критерий)
Returns the variance (based on the entire population) of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the variance. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
БДПРОИЗВЕД(база_данных, поле, критерий)
Returns the product of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values that you want to multiply together. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
БДСУММ(база_данных, поле, критерий)
Returns the sum of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the sum. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
БИЗВЛЕЧЬ(база_данных, поле, критерий)
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 #ЗНАЧ! is returned. If more than one row meets the criteria then the error #ЧИСЛО! is returned.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | The column number or column heading name of the value that you want to retrieve. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
БСЧЁТ(база_данных, [поле], критерий)
Returns the count of the number of rows in the database that meet the selection criteria and where the specified field contains a number.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | 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. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
БСЧЁТА(база_данных, [поле], критерий)
Returns the count of the number of rows in the database that meet the selection criteria and where the specified field is not blank.
| база_данных | A reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this. |
| поле | 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. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
ДМАКС(база_данных, поле, критерий)
Returns the maximum of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the maximum. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
ДМИН(база_данных, поле, критерий)
Returns the minimum of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the minimum. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
ДСРЗНАЧ(база_данных, поле, критерий)
Returns the average of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the average. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
ДСТАНДОТКЛ(база_данных, поле, критерий)
Returns the standard deviation (based on a population sample) of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the standard deviation. |
| критерий | 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 база_данных parameter if you want to select all the rows. |
ДСТАНДОТКЛП(база_данных, поле, критерий)
Returns the standard deviation (based on the entire population) of the values of a specified field in a 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. |
| поле | The column number or column heading name of the values of which you want to find the standard deviation. |
| критерий | 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 база_данных parameter if you want to select all the rows. |