Averageifs on Duplicate Columns
Results 1 to 4 of 4

Thread: Averageifs on Duplicate Columns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Averageifs on Duplicate Columns

    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.

  2. #2
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,225
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Averageifs on Duplicate Columns

    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.

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Averageifs on Duplicate Columns

    Quote Originally Posted by Marcelo Branco View Post
    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!

  4. #4
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,225
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Averageifs on Duplicate Columns

    You are welcome. Thanks for the feedback.

    M.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •