SUMIF with Condition

[Isacael]

Hi All

Sorry if I am doubling up on a question, but I am trying to do a SUMIF, but only to bring back the corresponding value for a matching condition. If you look at the example, I want to SUMIF the item #, but to bring back the value only for that customer. Hope this makes sense.
Cheers

[VBA Noob]

Maybe

=SUMPRODUCT((Sheet2!$A$6:$A$14=Sheet1!A4)*(Sheet2!$B$6:$B$14=Sheet1!B4)*(Sheet2!$C$6:$C$14))

VBA Noob