Função do Google Sheets

DCOUNT

Counts the number of cells containing numbers in a database that match specified conditions.

Gerar uma fórmula com IA A mesma função no Excel

Esta função funciona no Google Sheets da mesma forma que no Excel — mesma sintaxe e argumentos.

Sintaxe

DCOUNT(database, field, criteria)

DCOUNT is a database function that counts numeric values in a column based on criteria you define. It is useful for filtering datasets and performing conditional counts without using complex array formulas.

Argumentos

databaseobrigatórioThe range of cells that makes up the list or database.
fieldobrigatórioThe column label or index number used in the function.
criteriaobrigatórioThe range of cells that contains the specified conditions.

Exemplos

=DCOUNT(A1:C10, "Age", E1:E2)

Resultado: 5

Counts the number of entries in the 'Age' column where the criteria in E1:E2 are met.

Perguntas frequentes

Does DCOUNT count text cells?

No, DCOUNT only counts cells that contain numeric values. Use DCOUNTA if you need to count non-empty cells regardless of content.

Funções relacionadas

DSUM DAVERAGE COUNTIF DCOUNTA