Eliminating Duplicates and Correlating them to another Value

[KDR11]

I'm trying to create a table that will provide values based on duplicates being counted as 1.

For the totals I've achieved this by using the following formula and pressing ctrl+shift+enter:

=SUM(IF(FREQUENCY(IF(LEN(Table!A:A)>0,MATCH(Table!A:A,Table!A:A,0),""), IF(LEN(Table!A:A)>0,MATCH(Table!D:D,Table!A:A,0),""))>0,1))

Where Table is the worksheet that contains the data, and row A is the company name. The above formula allows me to have blank cells and will also allow the amount of data to vary.

I'm having a problem, however, assigning a different argument.

For instance if:


[TABLE="width: 183"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Purple[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]White[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]Purple[/TD]
[TD]Z[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

My total will correctly arrive at "8" because that's the total number of, in this case, colors involved.

Now I want to know how many colors there are that are associated with "X", "Y", or "Z"

X = 2
Y = 3
Z = 3

How can I accomplish this while still being allowed to have an infinite area within the column that does not count blanks and allows for text?

Thank you!