Difference between revisions of "Manuals/calci/DCOUNTA"
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | =DCOUNTA( | + | <div style="font-size:30px">'''DCOUNTA (Array,Field,Criteria)'''</div><br/> |
| − | + | *Where 'Array' is the range of cells that makes up the list or database | |
| − | *Where ' | + | *'Field' shows which column is used in the function and |
| − | + | *'Criteria' is the range of cells that contains the specified criteria. | |
| − | *' | + | **DCOUNTA() Counts nonblank cells in a database. |
| − | |||
| − | *' | ||
| − | |||
| − | *DCOUNTA() | ||
== Description == | == Description == | ||
| − | DCOUNTA( | + | DCOUNTA (Array,Field,Criteria) |
It counts the nonblank cells in a column of a list or database that match conditions that we specify. | It counts the nonblank cells in a column of a list or database that match conditions that we specify. | ||
| − | *The argument ' | + | *The argument 'Field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria. |
* A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'field' argument. | * A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'field' argument. | ||
| Line 123: | Line 119: | ||
*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | *[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | ||
*[http://en.wikipedia.org/wiki/Aggregate_function DCOUNTA] | *[http://en.wikipedia.org/wiki/Aggregate_function DCOUNTA] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 14:46, 24 August 2018
- Where 'Array' is the range of cells that makes up the list or database
- 'Field' shows which column is used in the function and
- 'Criteria' is the range of cells that contains the specified criteria.
- DCOUNTA() Counts nonblank cells in a database.
Description
DCOUNTA (Array,Field,Criteria)
It counts the nonblank cells in a column of a list or database that match conditions that we specify.
- The argument 'Field' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
- A 'column name' in quotes (e.g "Salary") or 'column number' (e.g 3, if Salary is 3rd column) can be used as 'field' argument.
- Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
- The Criteria columns should not overlap the list of data.
- DCOUNT() can be used to count the number of cells from a list of database that are numbers and match a specified criteria.
Examples
Consider the following table with Employee names, Age and Salary columns. Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.
?
| A | B | C | D | |
| 1 | Name | Age | Salary | Age |
| 2 | <40 | >5000 | >32 | |
| 3 | >30 | |||
| 4 | Name | Age | Salary | |
| 5 | John | 34 | 5500 | |
| 6 | Bill | 35 | 6500 | |
| 7 | Clark | 29 | 7000 | |
| 8 | Bob | 45 | ||
| 9 | Susan | 37 | 4000 | |
| 10 | Jill | 45 | 8000 |
=DCOUNTA(A4:C10,"Salary",A1:C2) : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age<40 and Salary>5000.
Displays 3 as a result.
=DCOUNTA(A4:C10,"Salary",D1:D2) : Counts the number of non-blank cells in the 'Salary' column, in the range A4 to C10, for the employees whose Age>32.
Displays 4 as a result.
There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.
=DCOUNTA(A4:C10,3,D1:D2) : Counts the number of non-blank cells in the 3rd column ('Salary'), in the range A4 to C10, for the employees whose Age>32.
Displays 4 as a result.
There are 5 cells in Salary column with Employee Age>32, but Salary field for Employee Bob is blank. Hence result displayed is '4'.
Related Videos
See Also
References