Google Sheets functions / Statistical
Statistical function · Google Sheets
AVERAGEIF function
Average of cells meeting one criterion.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.