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.
Bookmarks