DCOUNTA

DCOUNTA counts all non-blank values (text, numbers, or logical) in a database field for rows matching the criteria range. Use it instead of DCOUNT when the field may contain text entries that should be included in the count.

Excel

=DCOUNTA(A1:C5,"Product",E1:E2)

Google Sheets

=DCOUNTA(A1:C5,"Product",E1:E2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Set up the database and a criteria range with at least one column header and a condition row.
2Enter =DCOUNTA(database, field, criteria) — works on text fields where DCOUNT would return 0.
3Leave the field argument blank or use 0 to count records across any non-empty field.

Need a version for your data?

Try: “How many product entries are there for the East region?”

DSUM DAVERAGE DCOUNT

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

DCOUNTA

Try it with your data

How it works

Related