Wauvel

Excel like a finance pro.

← The library

Database function

DCOUNTA

Counts non-blank cells in a table column that match criteria.

Rarely usedDifficulty 1350 · AdvancedUsage rank #322 of 520
Practice · 2 questions →

When to use it

Counts non-blank cells in a column for rows matching the criteria range.

The shape of it

Syntax
=DCOUNTA(database, field, criteria)

Worked examples

  • Text column

    =DCOUNTA(A1:E11,"Rep",H1:H2) → 3

    Three West rows have a rep name.

  • OR conditions

    =DCOUNTA(A1:E11,"Rep",H1:H3) → 5

    West or East.

  • Numeric column

    =DCOUNTA(A1:E11,"Revenue",H1:H2) → 3

    Same as DCOUNT when all values are numeric.

Worth knowing

  • Use for text fields where DCOUNT would return 0.
  • Formulas returning "" count as non-blank.
  • COUNTIFS is the modern alternative.

Where it goes wrong

  • Header mismatches return 0.
  • Cells with spaces count.

Related

DSUMDAVERAGEDCOUNTDGETDMAXDMIN

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.