I'm trying to summarize pieces depending on a value in another column.

Hello,

So i'm trying to make a report on how each style is selling (pieces) and how many of the ones are NOOS (Never out of stock) and Seasonal colours.
In column C is the full SKU of the product, For example our SKU's are built "101068" First 3 digits "101" is the style. The fourth digit is the size. And the last 2 digits is the colour.

In Column J i have the "database" of the styles we have. And in Column K i have the seasonal colours, and column L i have the NOOS-colours.


In Column M i have SUM.IF formula to summarize how many pieces one style has sold.
In Column N i want to summarize how many pieces of those in M is seasonal colours.

I'm not sure how to build up the document from here. I'm kinda stuck.
If someone could help me i would be very happy.

Thank you in advance for any help!

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to consider amending your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Guideline #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I'm not sure how to build up the document from here. I'm kinda stuck.

I'm really not sure exactly what you are trying to do. Can you manually mock up a few rows of expected results to give us a clue?

Cell M2 on the Example sheet states: "Here i have collected all products that has a sku where the last two digits end with anything in column I."
Column I displays 05, however there are no SKU's ending in 05 so I don't understand why the expected result is 186.