Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

=AVERAGEIF(A2

Input the formula: =AVERAGEIF(A2:A6,"=Item*",B2:B6). Press Enter to get the result.