Conditional Count Related Formula Help

[xlmaniac]

Dear All,
I do have the following data set across A5:E30.
I would like to find out the unique count of styles that has been GRNed.
The formula needs to check in column E whether the cell is filled in with the GRN number or not. If the GRN number is there and then the unique count of styles against the GRN numbers needs to get populated under the summary section in cel lE2.
My desired result based on the below data set is 4.
I am unable to find out the correct path.
Could somebody help in fixing this out pls?
Sheet1

*	A	B	C	D	E
1	*	Department	Category	Sub Category	# Style(Desired Result)
2	*	Mens	Bottom	Casual Trouser	4
3	*	*	*	*	*
4	*	*	*	*	*
5	Department	Category	Sub Category	Style Name	GRN No
6	Mens	Bottom	Casual Trouser	Mercer County Mustard Chinos	12240
7	Mens	Bottom	Casual Trouser	Mercer County Mustard Chinos	12240
8	Mens	Bottom	Casual Trouser	Mercer County Mustard Chinos	12240
9	Mens	Bottom	Casual Trouser	Mercer County Mustard Chinos	12240
10	Mens	Bottom	Casual Trouser	Mercer County Mustard Chinos	12240
11	Mens	Bottom	Casual Trouser	Mercer County Rust Chinos	12240
12	Mens	Bottom	Casual Trouser	Mercer County Rust Chinos	12240
13	Mens	Bottom	Casual Trouser	Mercer County Rust Chinos	12240
14	Mens	Bottom	Casual Trouser	Mercer County Rust Chinos	12240
15	Mens	Bottom	Casual Trouser	Mercer County Rust Chinos	12240
16	Mens	Bottom	Casual Trouser	Mercer County Green *Chinos	12240
17	Mens	Bottom	Casual Trouser	Mercer County Green *Chinos	12240
18	Mens	Bottom	Casual Trouser	Mercer County Green *Chinos	12240
19	Mens	Bottom	Casual Trouser	Mercer County Green *Chinos	12240
20	Mens	Bottom	Casual Trouser	Mercer County Green *Chinos	12240
21	Mens	Bottom	Casual Trouser	Mercer County Blue *Chinos	*
22	Mens	Bottom	Casual Trouser	Mercer County Blue *Chinos	*
23	Mens	Bottom	Casual Trouser	Mercer County Blue *Chinos	*
24	Mens	Bottom	Casual Trouser	Mercer County Blue *Chinos	*
25	Mens	Bottom	Casual Trouser	Mercer County Blue *Chinos	*
26	Mens	Bottom	Casual Trouser	Dark Detroit Mens Chino	12409
27	Mens	Bottom	Casual Trouser	Dark Detroit Mens Chino	12409
28	Mens	Bottom	Casual Trouser	Dark Detroit Mens Chino	12409
29	Mens	Bottom	Casual Trouser	Dark Detroit Mens Chino	12409
30	Mens	Bottom	Casual Trouser	Dark Detroit Mens Chino	12409

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 74px;"><col style="width: 74px;"><col style="width: 95px;"><col style="width: 191px;"><col style="width: 152px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

 

[Aladin Akyurek]

Dear Sir,
Yes the department,category & subcategory also plays a role towrads the result delivery.
I have tweaked your formula and have got the final result.
Ths following is the snapshot.

I see you already added the additional conditions as required.

Once again thanks a lot for all your input & help.
...

You are welcome. Thanks for providing feedback.