This is a continuation of previous questions I've had. Thank you to all that have helped get me this far.
Background:
Their are multiple sheets in this excel file. The first sheet is the "Quote" sheet, fairly self explanatory, where all the quotes with multiple quantities go. The second sheet. "Orders", has the orders that were placed with the customer. The third sheet, "Sum ordered", is where I would like to sum the total number of parts ordered.
The complication is that I have multiple orders of the same part in the Quote tab, I need to sum all of the quantities ordered and have it return the answer on one line.
I have an example excel sheet attached. I manually filled out the "Sum ordered" tab to show what I'm looking for. Bonus points if you are able to also sum the total cost as well.
Thanks!
Bookmarks