Count by type

I am a novice in excel (2010). I own a t-shirt brand, when I put together a print run with multiple designs, that have multiple colored shirts per design (as shown in my screenshot). I need to then total up the number of: SMALL BLACK-T, MEDIUM BLACK-T, SMALL BLUE-T, ETC from all designs combined, so I know how many total of each size/color to order from the supplier.

Normally I manually transpose each BLACK-T row from each individual design, into a BLACK-T column (BLUE-T column, etc) & then sum those totals.

I'm curious if there is a way to some how tag garment names (part number, item code, serial number?), so that every row that uses BLACK-T in the design column, will automatically populate in the individual BLACK-T column, so that it will automatically total all black t's from a PO of 10 assorted designs. And the same for the other color garments?

Sorry I do not know a more concise way to ask this question. Refer to my attached image or WB file. (Above the red line is the section where I'd list all designs. Below the red line is where i'd like all the corresponding rows of each shirt color to populate. Doesn't have to be in this same exact format.)

Thanks.

\1
image hosting adult

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Also, please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.