81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Counts numeric values selected from a database table-like array or range using a SQL-like query.

How To Use in Sheets

DCOUNT(database, field, criteria)

External Links

Google Sheets DCOUNT Function | Criteria-based Database Count | Google Sheets Functions

Google Sheets DCOUNT function assists you to count data, which meets zero or more criterion, in a database. The D in the DCOUNT stands for database. You have to setup the criterion range with headers same as the database headers. The headers or the field names in the database and the criterion range should have the same case.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.