sumifs returning 0's

Hello,

What I am trying to do is populate the sales volume for each sku in yellow on sheet page 1. The data is being pulled from sheet 1. So, if you look at column C on page 1 sheet, it has the sku Direx 4L. What they are meaning to say is to consider all skus Direx 4L. So, in this case there are two skus of direx 4L (Sheet 1 column L... I have already removed all dups and these are the independent values). What I want to do is to add all of the ship quantity's for both Direx 4L skus and be able to match item to the branch that shipped them. See my formula on page 1 C:8, if your not catching what im throwing here. The formula may speak more. I hope someone can help. Thank you all in advance.