Excel Expert for Production Planning File

I need to create a production plan using Excel that will also track on hand inventory of materials. Most finished goods share like items to the files needs to reduce inventory accordingly. I tried using a sumifs and a sumif with a 'or' function and neither worked.