Summing up results from index, match

afika

New member
Joined
Nov 10, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
365
Hi All, hope you are having a good day..

I have used Index and match function to pick up data from a data base. However what I need is to sum up and values of multiple mathers.

Below, in the left is the data base, in the right is the picked up values for 'GL1-Brand1-Jan'.
But in the data base for 'Jan & Brand1' there are two GL1 values, 300 and 200, so I need to get the look up value sumed up to have the result of 500. (Formula used --> =INDEX($D$3:$F$7,MATCH($I3,$C3:$C7,0),MATCH(J$1&J$2,$D$1:$F$1&$D$2:$F$2,0)). Pls help, tahnks


JanJanJan JanJanJan
Brand1Brand2Brand3 Brand1Brand2Brand3
GL1300500300GL1300500300
GL2 400700700
GL3500400900
GL1200600900
GL2 100300200
 

Fluff

Member
Joined
Sep 9, 2018
Messages
136
Reaction score
0
Points
16
Excel Version(s)
O365
How about
=SUM(FILTER(FILTER($D$3:$F$7,$C$3:$C$7=$I3),($D$1:$F$1=J$1)*($D$2:$F$2=J$2)))
 
Top