Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

=AVERAGEIFS(C2

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