How to sum the values of a row for matching column headers using Index function

[chakrabmonoj]

Hey good people...

I am trying to sum a row of values, where the column header matches a given string....there will be multiple matches, precisely, one match every month for the 12 months chosen.

While I have got the result with Sumif and Sumproduct as will be shown in the file, I know there is a way to use the index and match function as well to get around to this. I am just not able to get it under my fingers.

In my case the index function is just returning the first instance of the match!

Any help appreciated

best regds.,

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: use index and match to sum column values with multiple matches
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

In my case the index function is just returning the first instance of the match!

That's exactly what the Match function is designed to do.
What is wrong with using sumifs, as that does what you need?