Try...

=AVERAGE(IF(K$2:HB$2=G$2,K3:HB3))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
Donovan wrote:

Does anyone know how to create a formula similar to sumif() but for
averages.


Hence:

I have a:

- range
- criteria
- AVG_range (as opposed to a sum_range)


The formula that I need would be =averageIF(K$2:HB$2,G$2,K3:HB3) which
is similar to =SUMIF(K$2:HB$2,G$2,K3:HB3) but does the averages based
on the criteria.

Are there any experts out there who knows how to do this?