Index match to sum multiple match columns

Hi I am trying to do a 2 WAY INDEX/MATCH FORMULA and return multiple matched columns and sum them up.

The following code works. I was wondering if there is a better way to do it? Also if I decide to Add SalesMonth3, Can it automatically adjust the area to sum up?

=SUM(INDEX(REPORT!$4:$7701,MATCH(A2,STYLE,0)+2,MATCH(SalesMonth1,SALES,0)),INDEX(REPORT!$4:$7701,MATCH(A2,STYLE,0)+2,MATCH(SalesMonth2,SALES,0)))

I'm using the following named ranges:
STYLE =REPORT!$F$6:INDEX(REPORT!$F:$F,COUNTA(REPORT!$F:$F)+5)
SALES =REPORT!$4:$4
SalesMonth1 =InfoSheet!$A$12 (FEB)
SalesMonth2 =InfoSheet!$A$13 (MAR)

I included a sample book.

Thank You!

Originally Posted by avk

Define name manager salesmonth3.

Formula:

=SUM(INDEX(REPORT!$4:$7701,MATCH(A2,STYLE,0)+2,MATCH(SalesMonth1,SALES,0)),INDEX(REPORT!$4:$7701,MATCH(A2,STYLE,0)+2,MATCH(SalesMonth2,SALES,0)),INDEX(REPORT!$4:$7701,MATCH(A2,STYLE,0)+2,MATCH(SalesMonth3,SALES,0)))

That is not the point. I know I need to define it. I was wondering If I can have the formula append

Formula:

INDEX(REPORT!$4:$7701,MATCH(A2,STYLE,0)+2,MATCH(SalesMonth3,SALES,0))

only if the SalesMonth3 is not null.
I can put a IF Statement, however that would just affect performance. This is just a sample data. Actual book has 12 sheets, with about 500 styles, Each style needs to have 7 data points looked up. Simple index/matching.
Also I was wondering if there is a shorter way to get the same results.

Originally Posted by shukla.ankur281190

May be try

B2

Formula:

=SUMPRODUCT((REPORT!$S$6:$X$57)*(REPORT!$F$6:$F$57=A2)*((REPORT!$S$5:$X$5="UNITS")*(REPORT!$S$4:$X$4=InfoSheet!$A$12)+(REPORT!$S$4:$X$4=InfoSheet!$A$13)))

Copy down.!

That is an Idea. I didn't think about using SUMPRODUCT.
Is it possible to have the last part (REPORT!$S$4:$X$4=InfoSheet!$A$12)+(REPORT!$S$4:$X$4=InfoSheet!$A$13) be combined in a dynamic range. So that I can add SalesMonth3 in =InfoSheet!$A$14 and it would add it to the formula?
How is performance on a huge data set?

Thanks!