Google Sheets-functie

AVERAGEIFS

Returns the average of all cells that meet multiple criteria.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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.

Argumenten

average_rangevereistThe actual range of cells to average.
criteria_range1vereistThe range of cells to evaluate against the first criteria.
criteria1vereistThe condition that defines which cells in criteria_range1 are averaged.

Voorbeelden

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

Resultaat: 150

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

Veelgestelde vragen

Can I use wildcards in the criteria?

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

Gerelateerde functies

AVERAGE AVERAGEIF SUMIFS COUNTIFS