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.

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.
	21.4.2.	=AVERAGEIFS(C2:C5,C2:C5,">5")	5")" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/averageifsc2c5c2c5gt95___Input_Formula_averageifsc2c5c2c595.PNG" width=200 height=40>