This article describes the formula syntax and usage of the AVERAGEIFS function, which returns the average (arithmetic mean) of all cells that meet multiple criteria. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.