AVERAGEIF(range,criteria,average_range) returns the average of all the cells in a range that meet a given criteria : AVERAGEIF « Statistical functions « Microsoft Office Excel 2007 Tutorial






=AVERAGEIF(B2:B5,"<8") gets the average of all values less than 23
=AVERAGEIF gets the average of all values less than 23
Input the formula: =AVERAGEIF(B2:B5,"<8"). Press Enter to get the result.

Referenced from Excel Help

21.3.AVERAGEIF
21.3.1.AVERAGEIF(range,criteria,average_range) returns the average of all the cells in a range that meet a given criteriaAVERAGEIF(range,criteria,average_range) returns the average of all the cells in a range that meet a given criteria
21.3.2.=AVERAGEIF(B2:B5,">5",C2:C5) returns the average of all values with a value greater than 25=AVERAGEIF(B2:B5,5",C2:C5) returns the average of all values with a value greater than 25" src="http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/averageifb2b5gt25c2c5_Returns_Average_Of_All___Input_Formula_.PNG" width=200 height=40>
21.3.3.=AVERAGEIF(A2:A6,"=Item*",B2:B6) returns the average of all values=AVERAGEIF(A2:A6,