Google Sheets reference

AVERAGEIFS in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Math & Statisticsintermediate

=AVERAGEIFS(D2:D100,B2:B100,"East",C2:C100,"Q1")

Also in Excel

See the full AVERAGEIFS reference for Excel — including all worked examples, common errors, and FAQ.