How to use averageif function?

[Bear]

AVERAGEIF(Data!A:A,A2,Data!B3:M3)


1) Search a value at another sheet named Data
2) if it match the value A2 (i.e. Apple)
3) average the column B3:M3

Thanks

 

[p45cal]

try:
=AVERAGE(INDEX(Data!$A$3:$M$4,MATCH(A2,Data!$A$3:$A$4,0),))

 

[Bear]

try:
=AVERAGE(INDEX(Data!$A$3:$M$4,MATCH(A2,Data!$A$3:$A$4,0),))

Thanks p45cal
You are my angel
the formula works perfectly