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 FishNew 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))

Messages:
318
Try SUMIFS.
3. ### HuiExcel NinjaStaff Member

Messages:
11,690
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