Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
DCOUNT
DCOUNT counts numeric entries in a specified column of a database for rows that satisfy multi-column criteria. It ignores text and blank values, making it ideal for auditing numeric data completeness within a filtered subset.
Excel
=DCOUNT(A1:C5,"Revenue",E1:E2)Google Sheets
=DCOUNT(A1:C5,"Revenue",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
Runs server-side · free · no signup
How it works
- 1Build your database table with a header row and a separate criteria range with matching column headers.
- 2Enter =DCOUNT(database, field, criteria) — the field must contain numeric data to be counted.
- 3Use DCOUNTA instead if you want to count non-empty cells including text.
Need a version for your data?
Try: “Count how many numeric revenue entries exist for the West region.”