How To Use DCOUNTA() Function in Google Sheets

Description

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

How To Actually Use DCOUNTA() in Sheets

DCOUNTA(database, field, criteria)

Try DCOUNTA yourself

Use the DCOUNTA function to count the non-empty values in the range B2:B10 based on the criteria in D1:D2. The result should be displayed in cell E1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

1 Better Sheets Tutorial

Build Your Own Net Promoter Score (NPS) Survey on a Web Site

Create an embeddable NPS system on a web page.

Advanced

AVERAGE() DCOUNTA() ROUND()

Learn more about the DCOUNTA() formula:

Generate a DCOUNTA() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses DCOUNTA(). 2 free AI generations, no signup. Members get unlimited use.

Generate a DCOUNTA() formula

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons