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
81% OFF online library of tutorials for mastering Google Sheets
One time purchase $199
Description
How To Use in Sheets
DCOUNT(database, field, criteria)
External Links
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.