DCOUNTA Function in Google Sheets

Count the number of non-empty cells in a database that meet specified criteria using the DCOUNTA function.

DCOUNTA Function

The DCOUNTA function in Google Sheets counts the number of non-empty cells in a specified field of a database that meet given criteria.

Syntax

DCOUNTA(database, field, criteria)
  • database: The range of cells that make up the database.
  • field: The column number or header name containing the values to count.
  • criteria: The range of cells that contain the conditions for counting.

Examples

  1. Basic Example

Count non-empty cells in field 2 of the database A1:C10 where criteria are in E1:E2:

=DCOUNTA(A1:C10, 2, E1:E2)
  1. Using Header Names

Count non-empty cells in the ‘Names’ column where criteria are in G1:G2:

=DCOUNTA(A1:C10, "Names", G1:G2)

Notes

  • Useful for counting cells that contain any data, not just numeric.
  • DCOUNT: Count numeric cells in a database that meet specified criteria.
  • DSUM: Sum values in a database that meet specified criteria.