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)
Hi Flora
=SUMPRODUCT((A2:A8=D14)*((B1:J1=A15)+(B1:J1=B15)+(B1:J1=C15))*B2:J8)
returns 121