DCOUNTA (database function)

<< Click to Display Table of Contents >>

DCOUNTA (database function)

Syntax:

DCOUNTA(DatabaseArea, Column, SearchCriteriaArea)

Description:

This returns the number of cells in a database area that match the conditions specified in the search criteria area.

Unlike the DCOUNT function, DCOUNTA not only counts cells containing numbers but also counts cells with text or logical values.

For more information on the use of database functions, see Working with database functions.

DatabaseArea is the cell range that contains the database. The first row of DatabaseArea must contain labels for the database columns (for example, Amount, Price, etc.).

If the argument Column is not empty, the function only considers cells from the corresponding column. You can specify Column by its relative column number or by its column label within double quotation marks (e.g., "Amount", "Price", etc.).

SearchCriteriaArea is a cell range containing one or more conditions that have to be fulfilled. The first row of SearchCriteriaArea has to contain column labels (e.g., Amount, Price, etc.).

See also:

DCOUNT