DCOUNTA

Excel Functions

Count matching records in a database

Syntax

EXCEL

=DCOUNTA(database, [field], criteria)

Arguments

Parameter	Description
`database`	Database range including headers.
`field`	[optional] Field name or index to count.
`criteria`	Criteria range including headers.

Return Value

Numeric count of matching records

Details

The Excel DCOUNTA function counts matching records in a database using a specified field and criteria. Unlike DCOUNT, which counts only numeric values, DCOUNTA counts both numeric and text values. Empty cells are ignored. Use DCOUNT to count only numeric values. The database argument is a range of cells that includes field headers, field is the name or index of the field to count, and criteria is a range of cells with headers matching those in database. Using the example above, you can count records where the color is "red" and price is > 10 with these formulas: Caution: If the value in a field is empty it will not be counted, even when criteria match. Note: The DCOUNTA function will count numbers or text in a given field, whereas DCOUNT only counts numeric values.

Examples

Example 1

Using the example above, you can count records where the color is "red" and price is > 10 with these formulas: