Averageifs on Duplicate Columns

[dtb912]

I have been searching around the boards without any luck. I am trying to find an average of a series of values based on column headers F4:EU4 where the rows names in A5:A37 are unique. I have tried =averageifs(index($F$5:$EU$37,,match("Mutual Fund Name",$A5:$A37)),$F$4:$EU$4,"Peer Group Percentile")

Where: Mutual Fund Name is the row name that varies (it is a cell in the actual formula), and Peer Group Percentile is the title of about 20 columns that I am trying to average.

When I use the formula above it just grabs the first value in the range and when I switch the range order it gives an error.

Any help would be great. Thanks.

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try
=AVERAGEIFS(INDEX($F$5:$EU$37,MATCH("Mutual Fund Name",$A5:$A37,0),0),$F$4:$EU$4,"Peer Group Percentile")

Hope this helps

M.

 

[dtb912]

Welcome to Mr Excel forum

Try
=AVERAGEIFS(INDEX($F$5:$EU$37,MATCH("Mutual Fund Name",$A5:$A37,0),0),$F$4:$EU$4,"Peer Group Percentile")

Hope this helps

M.

This worked. Thanks for the help!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.