1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum results from index match array

Discussion in 'Ask an Excel Question' started by Angela Fish, Apr 15, 2018.

  1. Angela Fish

    Angela Fish New Member

    Messages:
    1
    Hello! Hoping someone can help me. I am using an index match array formula that works wonderfully it looks up multiple values on a separate sheet to find the row and also the column and gives me the answer I want. The only hiccup is that there are multiple answers that I want it to sum all the times it finds it. I have tried sum product and have been unsuccessful with getting the formula to sum. Does anybody have any insight on how to get the below formula to also sum all of the results instead of just giving me the first match?
    =INDEX('Sheet1'!$BR$76:$CG$852,MATCH($A8&$D9,'Sheet1!$A$76:$A$852&'Sheet1'!$C$76:$C$852,0),MATCH(Summary!Z$3,'Sheet1'!$BR$4:$CG$4,0))
  2. AliGW

    AliGW Active Member

    Messages:
    179
    Try SUMIFS.
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,440
    Angela

    Firstly, Welcome to the Chandoo.org Forums

    If you can't work out using Sumifs, I'd suggest posting the file so we can see the data structures

Share This Page