=SUMIFS(Sheet1!D2:D11,Sheet1!A2:A11,Sheet2!$A2,Sh eet1!C2:C11,"*"&Sheet2!B$1&"*")

Try this:

=SUMPRODUCT(--(Sheet1!A2:A11=Sheet2!A2),--(ISNUMBER(SEARCH(Sheet2!B1,Sheet1!C2:C11))),Sheet1 !D2:D11)

--
Biff
Microsoft Excel MVP


"Fellipe C. Moreira" wrote in
message ...
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?

"Bob Umlas" wrote:

=SUMPRODUCT(N(Sheet1!A2:A11=Sheet2!$A2),N(NOT(ISER ROR(FIND(Sheet2!B1,Sheet1!C2:C11)))),Sheet1!D2:D11 )

"Fellipe C. Moreira" <Fellipe C. wrote
in
message ...
Hello, I have one here that I can't convert as well:

=SUMIFS(Sheet1!D2:D11,Sheet1!A2:A11,Sheet2!$A2,She et1!C2:C11,"*"&Sheet2!B$1&"*")

Any clue?

Thanks in advance!