Here is the situation:
I have an entire data sheet that contains details with top column title: [Category] [Item Code] [Brand] [Location Bin] [Qty]
Under my Category list, i have various types: "shoes", "bag", "jacket", "gloves", "jeans" followed by the corresponding Item Code, Brand, Location Bin, Qty.
Note that i only have 3 Brands in my store (hypothetically), PUMA, NIKE and ADDIDAS.
Now i have set a Category drop down list on cell C15.
then a default text on D18 is Puma and C18 is a formula count of Puma, D19 is Nike and C19 is a formula count of Nike , D20 is Addidas and C20 is a formula count of Addidas,.
How to write a formula that gives me a total count of Brand based on my Category?
For example in excel: I chose "shoes" under my category drop down list on C15.
Then C18, C19, C20 should give me a result automaticaly of the total count of shoes i do have for Puma, Nike and Addidas.
This will help me identify where are they located on my inventory (since staff here just put it everwhere)
Heeelp! My brain is about to explode, struggling for 3 days now and inventory starts this week.
Really appreciate your guidance or support, apologees if it was already threaded, but i couldnt find it exactly where.
I have an entire data sheet that contains details with top column title: [Category] [Item Code] [Brand] [Location Bin] [Qty]
Under my Category list, i have various types: "shoes", "bag", "jacket", "gloves", "jeans" followed by the corresponding Item Code, Brand, Location Bin, Qty.
Note that i only have 3 Brands in my store (hypothetically), PUMA, NIKE and ADDIDAS.
Now i have set a Category drop down list on cell C15.
then a default text on D18 is Puma and C18 is a formula count of Puma, D19 is Nike and C19 is a formula count of Nike , D20 is Addidas and C20 is a formula count of Addidas,.
How to write a formula that gives me a total count of Brand based on my Category?
For example in excel: I chose "shoes" under my category drop down list on C15.
Then C18, C19, C20 should give me a result automaticaly of the total count of shoes i do have for Puma, Nike and Addidas.
This will help me identify where are they located on my inventory (since staff here just put it everwhere)
Heeelp! My brain is about to explode, struggling for 3 days now and inventory starts this week.
Really appreciate your guidance or support, apologees if it was already threaded, but i couldnt find it exactly where.