Hi have the table below where in J8 have the following calculation: =INDEX($C$2:$G$7,MATCH(1,($A$2:$A$7=$J$3)*($B$2:$B$7=$J$4),0),MATCH($J$2,$C$1:$G$1,0))
As you see, it returns 68, which is the first hit. All fine here.
My problem is that I want to summarize all hits, i.e. 68 and 80 and get 148 (the yellow marked).
I have tried using sumif, sumifs, sum etc.. But I can't figure it out.
Grateful for help..
As you see, it returns 68, which is the first hit. All fine here.
My problem is that I want to summarize all hits, i.e. 68 and 80 and get 148 (the yellow marked).
I have tried using sumif, sumifs, sum etc.. But I can't figure it out.
Grateful for help..