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?