=AVERAGEIF(A2:A6,"=Item*",B2:B6) returns the average of all values : AVERAGEIF « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. AVERAGEIF
Input the formula: =AVERAGEIF(A2:A6,"=Item*",B2:B6). 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,