Help with Counting Unique Duplicates

[mandinko]

Ok I will keep it simple with two rows. What I am trying to do is count unique duplicate values from one row into another row.

[TABLE="width: 425"]
<colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Draw1[/TD]
[TD]Draw2[/TD]
[TD]Draw3[/TD]
[TD]Draw4[/TD]
[/TR]
[TR]
[TD]9/16/2014[/TD]
[TD]6[/TD]
[TD]9[/TD]
[TD]7[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]9/15/2014[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]9[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]
I am trying to count the number of repeat digits that occurred in draw 9/15 to 9/16. I am stuck with this formula and it gives me 3 which should be 2. This is my current formula and I am stuck right now. Please note I want to count the unique digits. For example the 6 and 9 was drawn on September 15 but it also came up on 9/16 too but it is counting the 9 twice but it should be once.

=SUM(IFERROR(SUM(1/COUNTIF(B21:E21,B20)),0)+IFERROR(SUM(1/COUNTIF(B21:E21,C20)),0)+IFERROR(SUM(1/COUNTIF(B21:E21,D20)),0)+IFERROR(SUM(1/COUNTIF(B21:E21,E20)),0)
)

Any help would be greatly appreciated.

Thanks

Calvin

 

[RoryA]

Don't worry, no-one is in trouble here! I just wanted to clarify the situation.