How to formulate and gives a result based on the category i selected

[Rock2]

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.

 

[seekerarcane]

Use SUMIF() function to count the numbers based on your criteria,

For Example, if you want to sum the number of shoes, by selecting the category in an array, then use the following following formula;

=SUMIF(Range,Criteria,Sum_Range)
=SUMIF(Cells reference of Category Column,"Shows",Cells Range for Shows column)

 

[AlanY]

try this in D18 and copy down

Excel 2012
	A	B	C	D	E
1	Category	Item Code	Brand	Location Bin	Qty
2	jeans		ADDIDAS		5
3	shoes		NIKE		7
4	shoes		NIKE		6
5	jacket		PUMA		9
6	bag		PUMA		6
7	gloves		NIKE		9
8	bag		NIKE		9
9	shoes		PUMA		6
10	gloves		NIKE		6
11	shoes		ADDIDAS		7
12	gloves		NIKE		8
13	jeans		ADDIDAS		8
14
15			shoes
16
17
18			PUMA	6
19			NIKE	13
20			ADDIDAS	7
Sheet3

Cell Formulas
Range	Formula
D18	=SUMIFS($E$2:$E$13,$A$2:$A$13,$C$15,$C$2:$C$13,$C18)