AVERAGEIFS « Statistical functions « Microsoft Office Excel 2007 Tutorial






21.4.AVERAGEIFS
21.4.1.AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria2...) returns the average (arithmetic mean) of all cells that meet multiple criteria.AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria2...) returns the average (arithmetic mean) of all cells that meet multiple criteria.
21.4.2.=AVERAGEIFS(C2:C5,C2:C5,">5")=AVERAGEIFS(C2:C5,C2:C5,5")" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/averageifsc2c5c2c5gt95___Input_Formula_averageifsc2c5c2c595.PNG" width=200 height=40>