Wauvel

Excel like a finance pro.

← The library

Database function

DCOUNT

Counts numeric cells in a table column that match criteria.

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

When to use it

Counts numeric cells in a column for rows matching the criteria range.

The shape of it

Syntax
=DCOUNT(database, field, criteria)

Worked examples

  • One condition

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

    Three West rows with numeric revenue.

  • OR conditions

    =DCOUNT(A1:E11,"Units",H1:H3) → 5

    West or East.

  • Row count

    =DCOUNT(A1:E11,,H1:H2) → 3

    With no field, counts matching rows.

Worth knowing

  • COUNTIFS for AND-only conditions.
  • DCOUNTA counts non-blank cells of any type.
  • Omitting the field counts all matching records.

Where it goes wrong

  • Text in the field column is not counted.
  • Header mismatches return 0.

Related

DSUMDAVERAGEDCOUNTADGETDMAXDMIN

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.