INDEX and MATCH help

[Yulechka]

Hello!
I am trying to sum the range looked by Index and Match for the certain segment, but it returns only the first row number, not a sum. Here is my formula: =SUM(INDEX($E:$G,MATCH($I$15,$B:$B,0),MATCH(F$2,$E$2:$G$2,0))). I need to sum numbers from E col for I15 segment. Please help!
Thank you in advance.

 

[blazy]

Hello!

It would be easier for us if you could post a sample file. On the first note, I think you should be using the SUMIF or SUMIFS function.

Please share the sample file if you do not manage to do it yourself.

Thanks.

 

[siva97237]

Index will give reference of only 1 cell so use
=SUM($E1:INDEX($E:$G,MATCH($I$15,$B:$B,0),MATCH(F$2,$E$2:$G$2,0)))
Like this
otherwise upload sample file as blazy said

 

[Yulechka]

Thank you very much, blazy and siva97237! Sum with Index and Match worked out perfectly.