Calculates the average of a specified range based on multiple criteria.
The AVERAGEIFS function in Microsoft Excel is a versatile statistical function designed to calculate the average of cells that meet multiple specified conditions. Its the older brother of AVERAGEIF and a cousin of SUMIFS and COUNTIFS. What is the AVERAGEIFS Function? The AVERAGEIFS function returns the arithmetic mean of all cells in a range that […]