Difference between revisions of "Documentation/How Tos/Calc: DCOUNTA function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
(15 intermediate revisions by 7 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: DCOUNTA function}} |
+ | {{Documentation/CalcFunc DatabaseTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_DCOUNT_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_DGET_function | ||
+ | }}__NOTOC__ | ||
== DCOUNTA == | == DCOUNTA == | ||
Line 12: | Line 17: | ||
:<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 | + | :<tt>'''field'''</tt> is an optional column, whose alphanumeric (ie. non-empty) cells are counted if their row matches the criteria. 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. If absent or 0, then the cell contents are ignored, and all rows matching the criteria are counted. |
:<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. | ||
− | The | + | The * [[Documentation/How_Tos/Calc: Database functions#Overview|Database functions overview]] fully describes the use of these parameters. |
− | <tt>'''DCOUNTA'''</tt> counts non-empty cells, that is those cells containing numbers, text or errors. | + | <tt>'''DCOUNTA'''</tt> counts non-empty cells, that is those cells containing numbers, text, TRUE/FALSE or errors. |
Line 29: | Line 34: | ||
{| border="1" | {| border="1" | ||
|-align="center" | |-align="center" | ||
− | | || | + | | ||A'''||B'''||C'''||D'''||E''' |
|-align="center" | |-align="center" | ||
− | | | + | |1'''||Name||Grade||Age||Distance to School||Weight |
|-align="center" | |-align="center" | ||
− | | | + | |2'''||Andy||3||9||150||40 |
|-align="center" | |-align="center" | ||
− | | | + | |3'''||Betty||4||10||1000|| |
|-align="center" | |-align="center" | ||
− | | | + | |4'''||Charles||3||10||300||no |
|-align="center" | |-align="center" | ||
− | | | + | |5'''||Daniel||5||11||1200||48 |
|-align="center" | |-align="center" | ||
− | | | + | |6'''||Eva||2||8||650||33 |
|-align="center" | |-align="center" | ||
− | | | + | |7'''||Frank||2||7||300|| |
|-align="center" | |-align="center" | ||
− | | | + | |8'''||Greta||1||7||200||36 |
|-align="center" | |-align="center" | ||
− | | | + | |9'''||Harry||3||9||1200||44 |
|-align="center" | |-align="center" | ||
− | | | + | |10'''||Irene||2||8||1000||no |
|-align="center" | |-align="center" | ||
− | | | + | |11'''|| || || || || |
|-align="center" | |-align="center" | ||
− | | | + | |12'''|| || || || || |
|-align="center" | |-align="center" | ||
− | | | + | |13'''||Name||Grade||Age||Distance to School||Weight |
|-align="center" | |-align="center" | ||
− | | | + | |14'''|| ||2|| || || |
|} | |} | ||
Line 84: | Line 89: | ||
: 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. | : 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. | ||
+ | <tt>'''DCOUNTA(A1:E10; E1; A13:E14)'''</tt> | ||
− | + | : also returns the number of children in the second grade whose weight has either been measured or marked as "no" (1). | |
− | + | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | {{SeeAlso|EN| | |
− | + | * [[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT]] | |
− | + | * [[Documentation/How_Tos/Calc: DSUM function|DSUM]] | |
− | + | * [[Documentation/How_Tos/Calc: DPRODUCT function|DPRODUCT]] | |
+ | * [[Documentation/How_Tos/Calc: DMAX function|DMAX]] | ||
+ | * [[Documentation/How_Tos/Calc: DMIN function|DMIN]] | ||
+ | * [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]] | ||
+ | * [[Documentation/How_Tos/Calc: DSTDEV function|DSTDEV]] | ||
+ | * [[Documentation/How_Tos/Calc: DSTDEVP function|DSTDEVP]] | ||
+ | * [[Documentation/How_Tos/Calc: DVAR function|DVAR]] | ||
+ | * [[Documentation/How_Tos/Calc: DVARP function|DVARP]] | ||
+ | * [[Documentation/How_Tos/Calc: DGET function|DGET]] | ||
− | + | * [[Documentation/How_Tos/Calc: COUNT function|COUNT]] | |
+ | * [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]] | ||
+ | * [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]] | ||
+ | * [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]] | ||
− | + | * [[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]] | |
− | + | ||
− | + | ||
− | + | ||
− | + | * [[Documentation/How_Tos/Calc: Database functions#Overview|Database functions overview]] | |
− | + | * [[Documentation/How_Tos/Calc: Database functions|Database functions]] | |
− | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | |
+ | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Database functions]] |
Latest revision as of 12:57, 30 January 2024
- Database Functions
- DcountDcountaDgetDmaxDminDaverageDproductDstdev
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 an optional column, whose alphanumeric (ie. non-empty) cells are counted if their row matches the criteria. 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. If absent or 0, then the cell contents are ignored, and all rows matching the criteria are counted.
- 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
-