Manuals/calci/DCOUNTA

DCOUNTA (Array,Field,Criteria)

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'.