Formula for Inventory Summary based on Inventory List

[EWolfe]

I am trying to come up with a formula on the 'Summary' tab (of the attached excel) based on the data existing in the 'Inventory' tab
On the Inventory tab I have some inventory items, they are separated by Item Type, Item, Long/Short Sleeve, Size, who they are Assigned To and Qty.
On the Summary tab I would like the B3 & B4 to analyze the data in the Inventory tab and count based on that criteria.

For example:
I would like cell B3 to look in the Inventory tab for: Shirt in Column B, and for Dress Shirt in Column C, and for Long Sleeve in Column D, and for M, in Column E.
When it finds a combination of all of those then I would like it to count how many instances that occurs.
In the example, it should find 2.

Thank you for your help.

[AliGW]

Have a look here (a very similar problem): https://www.excelforum.com/excel-for...-criteria.html