Forum Discussion

Flora Sim's avatar
Flora Sim
Brass Contributor
Mar 13, 2018
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.  
Formulas & Functions
tips and tricks
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 13, 2018

    Yes, without double dash it will even more shorter

    =SUMPRODUCT((A2:A8=D14)*ISNUMBER(MATCH(B1:J1,A15:C15,0))*B2:J8)
Jamil's avatar
Jamil
Bronze Contributor
Mar 13, 2018
Or more simplified

=SUMPRODUCT((A2:A8=D14)*--ISNUMBER(MATCH(B1:J1,A15:C15,0))*B2:J8)
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 13, 2018

Yes, without double dash it will even more shorter

=SUMPRODUCT((A2:A8=D14)*ISNUMBER(MATCH(B1:J1,A15:C15,0))*B2:J8)