Date | Draw1 | Draw2 | Draw3 | Draw4 |

9/16/2014 | 6 | 9 | 7 | 9 |

9/15/2014 | 6 | 1 | 9 | 3 |

<colgroup><col><col span="4"></colgroup><tbody>

</tbody>

=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