Using Averageifs in Excel 2007

if you want to use averageifs but you confused how to use it. do not be. just try this example bellow. you want to get average apple with type royal gala or orange from medan. try the formula given :

try this formula
cells A4 = AVERAGEIFS(C12:C24,A12:A24,"Apple",B12:B24,"Royal Gala")
cells A9 = AVERAGEIFS(C13:C25,A13:A25,"Orange",B13:B25,"Medan")