I have tried both of the above solutions posted above and both work to a point. The problem I am having now is when I copy the formulas to the full workbook (650+ rows of orders) the formulas aren't carrying on down the rows. In both attempts the formulas only work on the amount of rows from the example workbook. Am I missing a step?

I appreciate the assistance, the formulas are WAY beyond my scope of excel knowledge.