=AVERAGEIF(B2:B5,">5",C2:C5) returns the average of all values with a value greater than 25 : AVERAGEIF « Statistical functions « Microsoft Office Excel 2007 Tutorial





Input the formula: =AVERAGEIF(B2:B5,">5",C2:C5). Press Enter to get the result.
Input the formula: =AVERAGEIF










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,