Count IF rows meet criteria

[kbw]

I'm creating a punting spreadsheet on a first place (3 points), second place (2 points) and third place (1 point) system is in place.

We also have a game going where if you can Pick 3 out of 4, you get a bonus prize. I have created a leader board/dashboard type of thing, but am unsure of the formula on how to calculate the Points column in understanding that the one they get wrong could be in any race.

I have created the following logic:

Race: Score to be at least:
1 0-3
2 3
3 6
4 9

	Race 1	Points	Race 2	Points	Race 3	Points	Race 4	Points	Total
Player 1	Horse 1	3	Horse 2	0	Horse 7	1	Horse 2	3	7
Player 2	Horse 4	2	Horse 8	1	Horse 9	3	Horse 2	3	9

 

[bebo021999]

Could you point out:
1) Which columns contain the outcome?
2) How the outcome was calculated?