Difference between revisions of "Documentation/How Tos/Calc: DCOUNT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Issues:) |
m |
||
| Line 12: | Line 12: | ||
:<tt>'''database_table'''</tt> is a range defining the data to be processed. | :<tt>'''database_table'''</tt> is a range defining the data to be processed. | ||
| − | :<tt>'''field'''</tt> is the column to count. It may be a column number (1 is the first column of the database table, 2 is the second ...) or a column header (enclosed in quotation marks ””) or 0 to include all columns. | + | :<tt>'''field'''</tt> is the column to count. It may be a column number (1 is the first column of the database table, 2 is the second ...), or a column header (enclosed in quotation marks ””), or a cell referring to a column header, or 0 to include all columns. |
:<tt>'''criteria_table'''</tt> is a range containing criteria, to select which rows of the <tt>'''database_table'''</tt> to count. | :<tt>'''criteria_table'''</tt> is a range containing criteria, to select which rows of the <tt>'''database_table'''</tt> to count. | ||
| Line 79: | Line 79: | ||
<tt>'''DCOUNT(A1:E10; 5; A13:E14)'''</tt> | <tt>'''DCOUNT(A1:E10; 5; A13:E14)'''</tt> | ||
| − | : returns the number of children | + | : 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). |
| + | |||
| + | <tt>'''DCOUNT(A1:E10; E1; A13:E14)'''</tt> | ||
| + | |||
| + | : also returns the number of children in the second grade whose weight has been measured (2). | ||
Revision as of 21:56, 2 December 2007
DCOUNT
Counts the cells containing numbers in a column of a Calc 'database' table, in rows which meet specified criteria.
Syntax:
DCOUNT(database_table; field; criteria_table)
where
- database_table is a range defining the data to be processed.
- field is the column to count. It may be a column number (1 is the first column of the database table, 2 is the second ...), or a column header (enclosed in quotation marks ””), or a cell referring to a column header, or 0 to include all columns.
- 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:
DCOUNTA function, DSUM function, DPRODUCT function,
DMAX function, DMIN function, DAVERAGE function,
DSTDEV function, DSTDEVP function, DVAR function, DVARP function,
COUNT function, COUNTIF function, COUNTBLANK function
Conditional Counting and Summation
Issues:
The exact use of 0 as the field parameter is unclear, both in operation and in compatibility (issue 84168)
