Función de Google Sheets

AVERAGEIFS

Returns the average of all cells that meet multiple criteria.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

AVERAGEIFS(average_range, criteria_range1, criteria1, ...)

The AVERAGEIFS function calculates the arithmetic mean of cells that satisfy a set of given conditions. You can specify multiple ranges and corresponding criteria to filter the data before calculating the average.

Argumentos

average_rangeobligatorioThe actual range of cells to average.
criteria_range1obligatorioThe range of cells to evaluate against the first criteria.
criteria1obligatorioThe condition that defines which cells in criteria_range1 are averaged.

Ejemplos

=AVERAGEIFS(B2:B5, A2:A5, "Sales", C2:C5, ">100")

Resultado: 150

Calculates the average of values in B2:B5 where column A is 'Sales' and column C is greater than 100.

Preguntas frecuentes

Can I use wildcards in the criteria?

Yes, you can use the asterisk (*) and question mark (?) as wildcards in text-based criteria.

Funciones relacionadas

AVERAGE AVERAGEIF SUMIFS COUNTIFS