Counts numeric values selected from a database table-like array or range using a SQL-like query.
81% OFF online library of tutorials for mastering Google Sheets
DCOUNT()
Description
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.