Difference between revisions of "Documentation/How Tos/Calc: DCOUNTA function"
m |
(re-linked to Overview) |
||
| Line 17: | Line 17: | ||
| − | The '''[[Documentation/How_Tos/Calc: Database functions|Database functions overview]]''' fully describes the use of these parameters. | + | The '''[[Documentation/How_Tos/Calc: Database functions#Overview|Database functions overview]]''' fully describes the use of these parameters. |
| Line 90: | Line 90: | ||
=== See also: === | === See also: === | ||
| − | '''[[Documentation/How_Tos/Calc: Database functions|Database functions overview]]''' | + | '''[[Documentation/How_Tos/Calc: Database functions#Overview|Database functions overview]]''' |
'''[[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT function]]''', | '''[[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT function]]''', | ||
| Line 111: | Line 111: | ||
'''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF function]]''', | '''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF function]]''', | ||
'''[[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK function]]''' | '''[[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK function]]''' | ||
| + | |||
| + | '''[[Documentation/How_Tos/Calc: Database functions|Database functions]]''' | ||
'''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | '''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | ||
Revision as of 08:57, 27 December 2007
DCOUNTA
Counts the non-empty cells in a column of a Calc 'database' table, in rows which meet specified criteria.
Syntax:
DCOUNTA(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.
DCOUNTA counts non-empty cells, that is those cells containing numbers, text, TRUE/FALSE or errors.
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 | no |
| 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 | no |
| 11 | |||||
| 12 | |||||
| 13 | Name | Grade | Age | Distance to School | Weight |
| 14 | 2 |
DCOUNTA(A1:E10; 0; A13:E14)
- returns the number of children who are in the second grade (3).
DCOUNTA(A1:E10; 5; A13:E14)
- returns the number of children who are in the second grade, whose weight has either been measured or marked as "no" (1). Frank is not included, because his weight is blank. Irene is included, because her weight is marked as "no", which is text.
DCOUNTA(A1:E10; E1; A13:E14)
- also returns the number of children in the second grade whose weight has either been measured or marked as "no" (1).
See also:
DCOUNT function, DSUM function, DPRODUCT function,
DMAX function, DMIN function, DAVERAGE function,
DSTDEV function, DSTDEVP function, DVAR function, DVARP function,
COUNT function, COUNTA 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.
