Laddy,

Try to use sumif with array function:
=sum(if((sheet2!C1:C100=B1)*(sheet2!B1:B100="wareh ouse"),sheet2!D1:D100)

Note: end the formula with Ctrl + Shift + Enter

Roni