Sumif for inventory help

[Aussie1]

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

[ChemistB]

Where do you want the data taken from? What value in Scrap are you trying to match ?

[benishiryo]

hi Dave. you didn't mention which column of "May Inventory" is to match with which in "Production-Scrap Totals" & which column do you want to sum up. i'm assuming the following, so just change it accordingly. in O3 of May Inventory sheet;
=SUMIFS('Production-Scrap Totals'!$F$2:$F$46,'Production-Scrap Totals'!$B$2:$B$46,$B3,'Production-Scrap Totals'!$A$2:$A$46,O$2)
1. sum up Carts Produced (column F of Production-Scrap Totals) if;
2. Case ID (column B in Production-Scrap Totals) is equals to Item ID (B2 of May Inventory) and if;
3. Date (Column A in Production-Scrap Totals) is equals to O2 of May Inventory

[Aussie1]

I am wanting to pull the data from "Production-Scrap Totals" and put it in the corresponding dates and Item ID on "May Inventory".

Example. Here is a line from "Production Scrap Totals" I have abbreviated some. CP (Carts Produced) CTS (Carts Scraped) and so on.

Date Case ID Bullet ID Powder ID Charge CP CTS CS BS Pwdr (lbs)

5/22/13 C300WMPF S30C220HPBT H1000 77 1406 0 3 0 15.46600003

So if the date and ID (Case ID, Bullet ID and Powder ID) match then the "CP" number is put on the corresponding line on "May Inventory". So 1406 bullets would be put on the S30C220HPBT line, or 1406 Cases would be put on C300WMPF line on the same date (5/22/13) it was produced. Hope this makes sense.

Thank you for the fast replies!!


Dave

[davemon]

Dave
Try this and see if its what you're looking for.

Dave

[Aussie1]

Got it working!!!!

[Aussie1]

How do I make this as solved again...

[arlu1201]

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.