Difference between revisions of "Manuals/calci/DCOUNTA"
Line 151: | Line 151: | ||
=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",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 | + | =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. |
+ | Here, there are 5 Salary fields with employee age>32, but one cell is blank. Hence result displayed is '4'. |
Revision as of 19:22, 7 November 2013
DCOUNTA(db, fld, cri)
- Where 'db' is the range of cells that makes up the list or database
- 'fld' shows which column is used in the function and
- 'cri' is the range of cells that contains the specified criteria.
- DCOUNTA() counts the non-blank cells in the column of a list or database that match the specified criteria.
Description
DCOUNTA(db, fld, cri)
It counts the nonblank cells in a column of a list or database that match conditions that we specify.
- The argument 'fld' is optional. If not mentioned, the function counts all the numbers from database that match the criteria.
- 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.
Name | Age | Salary | Age |
<40 | >5000 | >32 | |
>30 | |||
Name | Age | Salary | |
John | 34 | 5500 | |
Bill | 35 | 6500 | |
Clark | 29 | 7000 | |
Bob | 45 | ||
Susan | 37 | 4000 | |
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. Here, there are 5 Salary fields with employee age>32, but one cell is blank. Hence result displayed is '4'.