Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

=AVERAGEIF(B2

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