B
Bob Umlas
=SUMPRODUCT(N(Sheet1!A2:A11=Sheet2!$A2),N(NOT(ISERROR(FIND(Sheet2!B1,Sheet1!C2:C11)))),Sheet1!D2
11)
11)
F
Fellipe C. Moreira
Thanks for the quick response Bob!
However I couldn't make it work, it's giving me 0 when it should give me
other value as the other does, any idea?
However I couldn't make it work, it's giving me 0 when it should give me
other value as the other does, any idea?
T
T. Valko
=SUMIFS(Sheet1!D211,Sheet1!A2:A11,Sheet2!$A2,Sheet1!C2:C11,"*"&Sheet2!B$1&"*")
Try this:
=SUMPRODUCT(--(Sheet1!A2:A11=Sheet2!A2),--(ISNUMBER(SEARCH(Sheet2!B1,Sheet1!C2:C11))),Sheet1!D211)
11,Sheet1!A2:A11,Sheet2!$A2,Sheet1!C2:C11,"*"&Sheet2!B$1&"*")Try this:
=SUMPRODUCT(--(Sheet1!A2:A11=Sheet2!A2),--(ISNUMBER(SEARCH(Sheet2!B1,Sheet1!C2:C11))),Sheet1!D2
11)
F
Fellipe C. Moreira
This one worked, thanks a lot!
T. Valko said:Try this:
=SUMPRODUCT(--(Sheet1!A2:A11=Sheet2!A2),--(ISNUMBER(SEARCH(Sheet2!B1,Sheet1!C2:C11))),Sheet1!D2
T
T. Valko
You're welcome. Thanks for the feedback!