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…