EXCEL

Excel AVERAGEIFS Function

The AVERAGEIFS function is a premade function in Excel, which calculates the average of a range based on one or more true or false condition.