Need assistance w/combining 3 project into 1! Sumifs and vlookups. Please help!

Hello,

Attached is a project that i have been given to do.

The attachments consists of 4 tabs.
-Style List
-Summary
-Detail
-pre transfer units (in other words, inventory by store, by project name)

I am trying to make my reporting much easier. Basically to begin with my pretransfer units tab consists of inventory of the 3 different store numbers for the 3 different projects.

So for example in the Summary Tab, i have set up a format that will allow me to have results on one tab for 3 projects which is named at B1, H1 and N1.

on C3, i would like to know the formula that will calculate how many units of inventory does store 3 have that belong to project name "Sneakers".
on h3, i would like to know the formula that will calculate how many units of inventory does store 3 have that belong to project name "Branded Tees".
on N3, i would like to know the formula that will calculate how many units of inventory does store 3 have that belong to project name "Nike".

My detail tab will now consist of the data that will allow me to understand what is considered an Authorized Transaction. The concat styles on Cells C8 and below are the concat styles that are also approved styles.

So i would like to know what formula can calculate the quantity of how many Authorized Units were transferred for each project. The style list tab has all my Concat Styles with its prospective Project Name.

I hope this makes sense. all i would like to know is the proper formulas when calculating total Authorized Units by store by project name, and same for Pretransfer units by store by project name.

Thank you sincerely for viewing and reading my post!

D

Thank you FDibbins. I did correct the fact that of the md sneakers and sneakers. So the pre transfer units calculated correctly for the Branded tees and Sneakers. But for Nike on cell O3 is coming up as 0. Also how can i calculate the authorized units portion? the detail tab shows the activity between the stores and the concat styles would be based off the style list tab.

Please let me know, if you can. Thanks

Ok i figured out the error on my end. But how do i calculate the Authorized Units? the detail is where i would check for the activity, then the concat style should be authorized if its listed in the Style List tab