DCOUNTA Google Sheets Formula

Generate Google Sheets DCOUNTA Formulas in seconds

Interactive Google Sheets Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Get advanced formulas, batch processing, and priority support

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Complex array formulas and dynamic ranges

Generate multiple formulas at once

Save and organize all your formulas

=DCOUNTA(A1:C5, "Name", A1:C2)

Counts non-empty cells in a column of a database range based on criteria in Google Sheets.

The DCOUNTA function counts non-empty cells (text, numbers, etc.) in a specified column of a database range that meet given criteria.

DCOUNTA is useful for tallying all non-blank entries, like counting names or items meeting conditions.

Database	Criteria	Formula	Result
A1:C5 = {Name, Age, Score; "John", 25, 80; "Jane", 30, 90; "Bob", 25, 70; "Alice", 35, 85}	A1:C2 = {Name, Age, Score; "", 25, ""}	=DCOUNTA(A1:C5, "Name", A1:C2)	2
A1:C4 = {Item, Qty, Price; "A", 10, 5; "B", 20, 10; "A", 15, 7}	A1:C2 = {Item, Qty, Price; "A", "", ""}	=DCOUNTA(A1:C4, "Item", A1:C2)	2
A1:C3 = {Name, Age, Score; "Tom", 40, 95; "", 30, 88}	A1:C2 = {Name, Age, Score; "", "", ">90"}	=DCOUNTA(A1:C3, "Name", A1:C2)	1