Sumif for inventory help

Hi there everyone. Been working on an inventory list and I am wanting to keep track of inventory monthly. I have attached the file so you can see.

I have been working on this for a bit so bear with me. There is a tab called "Production-scrap Totals" and "May Inventory" (which when I figure this out there will be a tab for every month).

So here is my issue... on the "May Inventory" I want data from the corresponding "Date" and "Item ID" to match data the from "Production-Scrap Totals".

I have been trying to use the sumif command with not much success.

Thank you much!!

Dave