# Thread: Sum - Index, Match, Match Thanks: 0 Likes: 0

1. ## Sum - Index, Match, Match

I am having some trouble using sum with Index, Match, Match.
My Formula is =SUM(INDEX(Sheet1!\$B\$1:\$R\$50,MATCH('July 2018'!\$B10,Sheet1!\$B\$1:\$B\$50,0),MATCH('July 2018'!\$O\$2,Sheet1!\$B\$1:\$R\$1,0)))

I need to cross match two categories and where that information meets up, I need to sum.
Thanks

2. ## Re: Sum - Index, Match, Match

Hi psrs0810,
I'm trying to understand your formula: you try to find cell C2 in the first row and B10 in Column B. Both of them can have multiple matches? Because when there is just 1 intersecting cell you'd just need a simple INDEX with 2 matches without a sum. Is that what you are looking for?
Cheers,
Koen

3. ## Re: Sum - Index, Match, Match

try this approach?
#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">
ABCDEFGHIJKLMNO
1JanFebMarAprMayJunJulAugSepOctNovDec
2Paul121416182022242628303234Paul
3George242628303234363840424446Jul
4Ringo36384042444648505254565884
5Paul485052545658606264666870

#DAE7F5 ;color: #161120">Sheet6

#FFFFFF " >
Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120">
CellFormula
#DAE7F5 ;color: #161120">O4=SUMPRODUCT((A2:A5=O2)*((B1:M1=O3)*(B2:M5)))