# Points scoring system

1. ## Points scoring system

Alright guys

am looking to get some help with this formula, what i want to do its this:

These are on sheet 1

Home Away Result
Game 1 3 2 H
Game 2 0 2 A
Game 3 2 3 A
Game 4 0 0 D
Game 5 3 2 H
Game 6 0 2 A
Game 7 1 2 A

on sheet 2 if someone submits these scores for the

Home Away Result Score(this is what i need the formula for)
Game 1 1 1 D 0
Game 2 2 0 H 0
Game 3 0 2 A 1
Game 4 1 3 A 1
Game 5 3 2 H 3
Game 6 0 1 A 1
Game 7 2 1 H 0

i.e if the correct score is submitted then 3 points is awarded, if the correct result is submitted 1 point and wrong result 0 points

any help will be appreciated.
fessy

2. ## Re: Points scoring system

Your example data doesn't make sense. At least, for Game 4.

3. ## Re: Points scoring system

Sorry its like this

Home Away Result
Game1, 2 0 h

This is the reality score

And if some one predicts a score like this

Home Away Result
Game 1, 1 0 h

This will score a point in my system. A correct score with reality and predicted is 3 points and wrong result 0 points

Hope this makes it clear?

Fessy

And game 4?

5. ## Re: Points scoring system

Game 4 is a score of
0-0 which is a draw in reality
Predicted was 1-3 and the away team win arhhhhhh that should be 0 for the score

Sorry

6. ## Re: Points scoring system

OK, one way, E2 and copied down:

Formula:
`Please Login or Register  to view this content.`

Regards, TMS

7. ## Re: Points scoring system

Tms you are a gurgu thanks for that it was exactly what i was trying to do

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1