Funkcji baz danych

[ ] indicates optional parameters

BD.ILE.REKORDÓW(baza, [pole], kryteria)
BD.ILE.REKORDÓW.A(baza, [pole], kryteria)
BD.ILOCZYN(baza, pole, kryteria)
BD.MAX(baza, pole, kryteria)
BD.MIN(baza, pole, kryteria)
BD.ODCH.STANDARD(baza, pole, kryteria)
BD.ODCH.STANDARD.POPUL(baza, pole, kryteria)
BD.POLE(baza, pole, kryteria)
BD.SUMA(baza, pole, kryteria)
BD.WARIANCJA(baza, pole, kryteria)
BD.WARIANCJA.POPUL(baza, pole, kryteria)
BD.ŚREDNIA(baza, pole, kryteria)


Funkcji baz danych

BD.ILE.REKORDÓW(baza, [pole], kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe 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.
kryteriaA 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.


BD.ILE.REKORDÓW.A(baza, [pole], kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe 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.
kryteriaA 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.


BD.ILOCZYN(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values that you want to multiply together.
kryteriaA 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.


BD.MAX(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the maximum.
kryteriaA 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.


BD.MIN(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the minimum.
kryteriaA 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.


BD.ODCH.STANDARD(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the standard deviation.
kryteriaA 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.


BD.ODCH.STANDARD.POPUL(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the standard deviation.
kryteriaA 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.


BD.POLE(baza, pole, kryteria)

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.

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the value that you want to retrieve.
kryteriaA 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.


BD.SUMA(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the sum.
kryteriaA 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.


BD.WARIANCJA(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the variance.
kryteriaA 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.


BD.WARIANCJA.POPUL(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the variance.
kryteriaA 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.


BD.ŚREDNIA(baza, pole, kryteria)

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

bazaA reference to the cells that contain the database (including the column headings). It is usually easiest to use a defined name for this.
poleThe column number or column heading name of the values of which you want to find the average.
kryteriaA 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.