EXCEL

Excel AVERAGEIF Function

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