OOoES/Traduccion/Calc: Funcion BDCONTAR

BDCONTAR

Cuenta las celdas que contienen números en una columna de una tabla de 'basededatos' de Calc, en filas que cumplan con el criterio especificado.

Sintaxis:

BDCONTAR(base_de_datos; campo; criterios)

donde

base_de_datos es un rango definido de datos a ser procesados.

campo es la columna a contar. Este puede ser un número de columna (1 es la primera columna de la base de datos, 2 es la segunda ...), o un encabezado de columna (entre comillas ””), o una celda referida a un encabezado de columna, o 0 para incluir todas las columnas.

criteria_table is a range containing criteria, to select which rows of the database_table to count.

The Database functions overview fully describes the use of these parameters.

Example:

In this spreadsheet:

	A	B	C	D	E
1	Name	Grade	Age	Distance to School	Weight
2	Andy	3	9	150	40
3	Betty	4	10	1000
4	Charles	3	10	300
5	Daniel	5	11	1200	48
6	Eva	2	8	650	33
7	Frank	2	7	300
8	Greta	1	7	200	36
9	Harry	3	9	1200	44
10	Irene	2	8	1000	42
11
12
13	Name	Grade	Age	Distance to School	Weight
14		2

DCOUNT(A1:E10; 0; A13:E14)

returns the number of children who are in the second grade (3).

DCOUNT(A1:E10; 5; A13:E14)

returns the number of children in the second grade whose weight has been measured (2). Frank is not included, because his weight is blank (not a number).

DCOUNT(A1:E10; E1; A13:E14)

also returns the number of children in the second grade whose weight has been measured (2).

See also:

Database functions overview

DCOUNTA function, DSUM function, DPRODUCT function,

DMAX function, DMIN function, DAVERAGE function,

DSTDEV function, DSTDEVP function, DVAR function, DVARP function,

DGET function

COUNT function, COUNTIF function, COUNTBLANK function

Database functions

Conditional Counting and Summation

Issues:

The exact use of 0 as the field parameter is unclear, both in operation and in compatibility (issue 84168)