Manuals/calci/DCOUNTA

From ZCubes Wiki
Jump to navigation Jump to search
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'.

Related Videos

DCOUNTA

See Also

References