Okay, I think I got it... :)

=COUNT(1/FREQUENCY(IF(A2:A83=F2,IF(D2:D83<"",MATCH(B2:B83& "#"&C2:C83,B2:
B83&"#"&C2:C83,0))),ROW(A2:A83)-ROW(A2)+1))

....where F2 contains the department of interest. Note that the formula
needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
JR573PUTT
wrote:

Detail sheet is as follows:

COLUMN A: DEPT, EXAMPLE 331, 332
COLUMN B: STYLE NAME, EXAMPLE: THALIA, JANE
COLUMN C: COLOR, EXAMPLE: BLACK, WHITE
COLUMN D: QTY , EXAMPLE: 12, 24


SUB STYLE NAME COLOR QTY
331 RAVEN BLACK
331 RAVEN WHITE
331 THALIA WHITE
331 THALIA PINK
331 JANE BLACK
331 JANE BLACK 12
331 JANE BLACK 24
331 JANE GOLD 12
331 JANE SILVER 12
331 JANE SILVER 24
331 JANE WHITE
331 JANE WHITE 24
331 JANE RED 12
331 RACY BLACK
331 RACY BONE
331 JANIE BLACK 12
331 JANIE BLACK 24
331 JANIE BRONZE
331 JANIE ORANGE
331 JANIS BLACK
331 JANIS WHITE
331 JANIS RED
331 JANIS BLACK 12
331 JANIS WHITE 12
331 JANIS RED 12
331 VIVIAN BLACK
331 VIVIAN WHITE
331 VIVIAN-P BLACK
331 VIVIAN-L BLACK
331 VIVIAN-L RED
331 VIVIAN-L NAVY
331 VIVIAN-L WHITE
331 VIOLET BLACK
331 VIOLET BROWN
331 ELSIE F BEIGE 12
331 KITTY SILVER
331 KITTY BLACK
331 KITTY BRONZE
331 PIXIE GREEN 12
331 PIXIE ORANGE 12
331 PIXIE WHITE 12
331 CELESTE BLACK
331 CELESTE BONE
331 CELESTE BROWN
331 RACHELD BROWN 12
331 RACHELD GREEN 12
331 RACHELD BONE 12
331 MEGAN BLACK
331 MEGAN WHITE
331 SHEENA BLACK
331 SHEENA GOLD
331 SHEENA SILVER
331 SHEENA WHITE
331 SHEENA BLACK 12
331 SHEENA GOLD 12
331 SHEENA SILVER 12
331 SHEENA WHITE 12
331 LAVAL BONE 12
331 LAVAL BROWN 12
331 LAVAL GREEN 12

332 SHELLY BLACK
332 SHELLY NATURAL
332 SHELLY BLACK
332 SHELLY NATURAL
332 SHELLY BLACK 24
332 SHELLY NATURAL 24
332 SHELLY BLACK
332 SHELLY GREEN
332 SHELLY LAVENDER
332 SHELLY YELLOW
332 SHELLY GREEN 12
332 SHELLY YELLOW 12
332 SHELLY LAVENDER
332 SHELLY BRONZE 12
332 SHELLY ORANGE 12
332 FIONA BLACK
332 FIONA BRONZE
332 PATRICIA BLACK 12
332 PATRICIA WHITE 12
332 PATRICIA TURQ 12
332 PATRICIA PURPLE 12

Summary sheet is as follows:


In the ACT u column I have a sumproduct formula that adds the pairs for
each subdepartment and works fine.

The formla I am struggling with is for the SKUs column, there are 23
SKUS or unique styles in column D, example, Jane in black, RachelD in
green, etc.....The Jane in black is listed twice because of different
purchase orders of same product, I only want to count the Jane black
once if there is a value in the qty column. This is called a SKU
count, this is important because a display only holds X
amount.................

I need a formula to count how many unique entries are in column D.

The answer I am looking for 331 is 23 because there are 23 unique skus
in column d with qty.


DEPT Name PLAN u ACT u U -/+ SKUs
331 CLOSED 420 324 -96 #N/A
332 OPEN 552 768 216 50