Forum Discussion
Solved
How to Sum the result of Matched return as SUMPRODUCT Didn't work.
how can i get the 121 in this example? SUMPRODUCT didn't work.
Yes, without double dash it will even more shorter
=SUMPRODUCT((A2:A8=D14)*ISNUMBER(MATCH(B1:J1,A15:C15,0))*B2:J8)
Try this: =SUMPRODUCT(($A$2:$A$8=$A$11)*($B$1:$D$1=$A$12)*($B$2:$D$8))+SUMPRODUCT(($A$2:$A$8=$A$11)*($B$1:$D$1=$A$13)*($B$2:$D$8))+SUMPRODUCT(($A$2:$A$8=$A$11)*($B$1:$D$1=$A$14)*($B$2:$D$8))
I've also attached an example file with the other formulas that were given as answers so you can further understand the differences and how they work.
Thank you Matt. Appreciated!