Question

A function that gets the average of a range cells

Answer 1

The AVERAGEIF function in Microsoft Excel calculates the average (arithmetic mean) of all integers in a range of cells depending on a set of conditions. The AVERAGEIF function is a Statistical Function that comes with Excel.

This Excel lesson includes examples and syntax for using the AVERAGEIF function.

Explanation :

The AVERAGEIF function in Microsoft Excel calculates the average (arithmetic mean) of all integers in a range of cells depending on a set of conditions.

The AVERAGEIF function is a Statistical Function that comes with Excel. It may be used in Excel as a worksheet function (WS). The AVERAGEIF function is a worksheet function that may be used in a formula in a worksheet cell.