Funzione di Google Sheets

DCOUNTA

Counts the number of non-empty cells in a database column that match specified conditions.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

DCOUNTA(database, field, criteria)

DCOUNTA counts cells that are not empty in the specified field of records that match the criteria. It is particularly useful for analyzing large datasets where you need to filter by multiple conditions before counting.

Argomenti

databaseobbligatorioThe range of cells that makes up the list or database.
fieldobbligatorioThe column label or index used in the function.
criteriaobbligatorioThe range of cells that contains the specified conditions.

Esempi

=DCOUNTA(A1:C10, "Sales", E1:F2)

Risultato: 5

Counts the number of non-empty 'Sales' entries in the database that meet the criteria defined in E1:F2.

Domande frequenti

What is the difference between DCOUNT and DCOUNTA?

DCOUNT counts only numeric cells, while DCOUNTA counts any non-empty cell, including text.

Funzioni correlate

DCOUNT DSUM COUNTA DGET