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
Bookmarks