AVERAGEIF Function In Excel | Advance Excel Course

The AVERAGEIF function in Excel is used to find the average of a range of cells that meet a certain condition.

• range: the range of cells to evaluate against the criteria.
• criteria: the condition or criteria that must be met. This can be a number, text, date, logical expression or cell reference.
• [average_range] (optional): the range of cells that will be used to calculate the average. If omitted, the function will use the same range as the range argument.