Excel functions / Database

DCOUNTA function

Counts the cells that are not empty in a column of a table for the rows that meet conditions written in cells.

Syntax

=DCOUNTA(database, field, criteria)

Arguments

When to use it

DCOUNTA counts the cells that are not empty in one column of a table, for the rows that meet conditions in a criteria range: numbers and text alike.

Examples

  1. North orders with a rep filled in

    ABCDE
    1Region
    2North3
    3
    4RegionRepSales
    5NorthAna1200
    6SouthBen800
    7NorthChloe900
    8WestAna400
    9NorthAna300

    In E2: =DCOUNTA(A4:C9, "Rep", A1:A2) → 3

    Try this example

Common mistakes

DCOUNTA in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try DCOUNTA in the playground

Related functions