[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