View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Domenic Domenic is offline
external usenet poster
 
Posts: 256
Default similar to sumif() but for averages

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?