Help needed! Identifying duplicate values with functions

Hey guys, I am really stuck so any help would be hugely appreciated.

I am creating an inventory model for work and have created a dashboard where you can choose a part number and the availability of that part shows up and then you can enter the number of items ordered. Once the user hits enter, the order goes into a purchase log with the time and date of the order.

Here is where I am having trouble... I want to subtract the purchase log orders from the stock levels for each part number which are displayed in various sheets. I can do that when a part has only entered the log once, but when there is more than one transaction for the same part number I can’t seem to solve the issue. I tried an index and match function but that simply returns the first transaction for each part number.

Please refer the the attached example where I would like to adjust the stock level in the part number sheets.

Again, any help would be hugely appreciated!

Thanks,

PdubNZL

Hi

Apples Part Number!C2: =SUMIF('Example Purchase Log'!D:D,'Apples Part Number'!A2,'Example Purchase Log'!B:B)

This does assume that the part number is unique for the Item. if this is not the case, then you could use a sumproduct formula to do the combination of part number and item.

HTH

rylo

Hey guys,

Thanks you so much for the help. Problem solved!

I cant thank you enough