Difference between revisions of "Documentation/How Tos/Calc: DCOUNTA function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎See also:)
(→‎See also:)
Line 90: Line 90:
  
 
=== See also: ===
 
=== See also: ===
−
'''[[Documentation/How_Tos/Calc: Database functions#Overview|Database functions overview]]'''
+
'''[[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: DCOUNT function|DCOUNT function]]''',
+
'''[[Documentation/How_Tos/Calc: COUNT function|COUNT]]''',
−
'''[[Documentation/How_Tos/Calc: DSUM function|DSUM function]]''',
+
'''[[Documentation/How_Tos/Calc: COUNTA function|COUNTA]]''',
−
'''[[Documentation/How_Tos/Calc: DPRODUCT function|DPRODUCT function]]''',
+
'''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]]''',
 +
'''[[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]]'''
  
−
'''[[Documentation/How_Tos/Calc: DMAX function|DMAX function]]''',
+
'''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]'''
−
'''[[Documentation/How_Tos/Calc: DMIN function|DMIN function]]''',
+
−
'''[[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE function]]''',
+
  
−
'''[[Documentation/How_Tos/Calc: DSTDEV function|DSTDEV function]]''',
+
'''[[Documentation/How_Tos/Calc: Database functions#Overview|Database functions overview]]'''
−
'''[[Documentation/How_Tos/Calc: DSTDEVP function|DSTDEVP function]]''',
+
−
'''[[Documentation/How_Tos/Calc: DVAR function|DVAR function]]''',
+
−
'''[[Documentation/How_Tos/Calc: DVARP function|DVARP function]]''',
+
−
 
+
−
'''[[Documentation/How_Tos/Calc: DGET function|DGET function]]'''
+
−
 
+
−
'''[[Documentation/How_Tos/Calc: COUNT function|COUNT function]]''',
+
−
'''[[Documentation/How_Tos/Calc: COUNTA function|COUNTA function]]''',
+
−
'''[[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF function]]''',
+
−
'''[[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK function]]'''
+
−
 
+
−
'''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]'''
+
  
 
'''[[Documentation/How_Tos/Calc: Database functions|Database functions]]'''
 
'''[[Documentation/How_Tos/Calc: Database functions|Database functions]]'''

Revision as of 18:14, 11 September 2008


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, DSUM, DPRODUCT, DMAX, DMIN, DAVERAGE, DSTDEV, DSTDEVP, DVAR, DVARP, DGET

COUNT, COUNTA, COUNTIF, COUNTBLANK

Conditional Counting and Summation

Database functions overview

Database functions

Functions listed alphabetically, Functions listed by category

Issues:

The exact use of 0 as the field parameter is unclear, both in operation and in compatibility.

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_DCOUNTA_function&oldid=92392"
Personal tools