81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

DCOUNTA()

Description

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

How To Use in Sheets

DCOUNTA(database, field, criteria)

External Links

Google Sheets - Database Functions

Learn how to use database functions in Google Sheets.

Google Docs Help

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.