SumProductIf

[JTM2019HYO]

first try:

=SUMIF(ELECTRICAS!$K$4:$K$617;"*"&C2&"*";ELECTRICAS!$I$4:$I$623)

... but with this method i can not sum multiple times at same row.

I tried (suggested in another post):

=SUMPRODUCT((ISNUMBER(SEARCH(ELECTRICAS!$K$4:$K$617;C2)))*ELECTRICAS!$I$4:$I$617)

... to solve this I tried match "*"&C2&"*" with ELECTRICAS!$K$4:$K$617, if yes, then result should = ELECTRICAS!$I$4:$I$623 * NumberTimesIsRepeated("*"&C2&"*", only in the row where we found match ELECTRICAS!$K$4:$K$617)

but looks like is there any error, any help?

[kvsrinivasamurthy]

In G2 copied down

=IF(C2="","",SUMPRODUCT(ISNUMBER(FIND(C2,ELECTRICAS!$K$4:$K$617))*ELECTRICAS!$I$4:$I$617))

[JTM2019HYO]

I am not too expert in excel but looks like your formula is equivalent to sumif

=IF(C2="";"";SUMPRODUCT(ISNUMBER(FIND(C2;ELECTRICAS!$K$4:$K$617))*ELECTRICAS!$I$4:$I$617))

and

=SUMIF(ELECTRICAS!$K$4:$K$617;"*"&C2&"*";ELECTRICAS!$I$4:$I$623)

for example, D2 AND G2 are equals but in ELECTRICAS!K68 "CDL-11" String and ELECTRICAS!I68 with value 1000

... the result should be 14930

... and if I add "CDL-11;CDL-11;CDL-11" the result should "16930" because 1000*3 times repeated the matched string.