Hello everyone,
I have been searching the forum and google for a possible answer to my problem, but have not been able to find a solution that matches what I need. I have a workbook that contains all of my purchase orders for last year. Each purchase order is contained on it's own worksheet. I have created a worksheet called 'Item Sales 2016', and I want to find formulas that will search each PO worksheet for each item number, find the qty of that item sold on each worksheet, and then sum those numbers and return the total onto the 'Item Sales 2016' sheet. I then want it to also search each worksheet for the item number and find the "landed cost" for each item on each PO and return the average cost for that item. Each PO sheet is set up in exactly the same way.
So for example, for my first Item #, I want the formula to search each PO worksheet and have it add up the numbers in the "Qty" column and have that total returned on the "Total Sold" column of the 'Item Sales 2016' sheet. Then I want the total in the "Landed Cost Each" column for that item to be averaged out across all PO's and returned on the "Average Landed Cost" column of the 'Item Sales 2016' sheet.
I hope this is clear enough, and please feel free to ask for further clarification.
Thank you in advance for your help.
Bookmarks