AVERAGEIFS(average_range,criteria_range1,criteria1,criteria_range2,criteria2...) returns the average (arithmetic mean) of all cells that meet multiple criteria. : AVERAGEIFS « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. AVERAGEIFS
Input the formula: =AVERAGEIFS(B2:B5,B2:B5,">7",B2:B5,"<9"). Press Enter to get the result.
Input the formula: =AVERAGEIFS

Referenced from Excel Help

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>