Manuals/calci/DCOUNTA
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 conditions that we specify.
It counts the nonblank cells in a column of a list or database that match conditions that we specify.
DCOUNTA
[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]
[javascript:ToggleDiv('divExpCollAsst_4') C1 C2 C3 ]
[javascript:ToggleDiv('divExpCollAsst_4') R1 Name Age Salary ]
[javascript:ToggleDiv('divExpCollAsst_4') R2 <30 ]
[javascript:ToggleDiv('divExpCollAsst_4') R3 >40 >5000]
[javascript:ToggleDiv('divExpCollAsst_4') R4 Name Age Salary]
[javascript:ToggleDiv('divExpCollAsst_4') R5 John 34 5500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R6 Bill 35 6500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R7 Clark 29 7000 ]
[javascript:ToggleDiv('divExpCollAsst_4') R8 Bob 45 9000]
[javascript:ToggleDiv('divExpCollAsst_4') R9 Susan 37 4000]
[javascript:ToggleDiv('divExpCollAsst_4') R10 Jill 45 8000 ]
[javascript:ToggleDiv('divExpCollAsst_4') I.e =DCOUNTA(C1R4:C3R10,”Salary”,C1R1:C2R3) is 3]
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Name | Age | Salary | 3 |
| Row2 | <30 | |||
| Row3 | >40 | >5000 | ||
| Row4 | Name | Age | Salary | |
| Row5 | John | 34 | 5500 | |
| Row6 | Bill | 35 | 6500 | |
| Row7 | Clark | 29 | 7000 | |
| Row8 | Bob | 45 | 9000 | |
| Row9 | Susan | 37 | 4000 | |
| Row10 | Jill | 45 | 8000 |
