Any excel experts about?

[ifm]

Hello, i need to modify a spreadsheet i found online.
It's currently for a football league but i want to change it to a darts individual league.
The problem i am having is that the points system is not what i want, currently it awards points for win, lose and draw but i want it to be:
5 points for 3-0
4 points for 2-1
1 point for 1-2
0 points for 0-3
Its been years since i mucked about with excel and i don't have the time to relearn it as the league starts tomorrow!!!
Thanks for any help, file is here:

http://cid-89088a19a0d936ba.skydrive.live.com/browse.aspx/Public

[M3boy]

I may take a look later for you if I get time

[Grier78]

I am looking at it now, will have it ready in a couple of hours. Msg me your email address and I will send it you when its done.

[M3boy]

I am looking at it now, will have it ready in a couple of hours. Msg me your email address and I will send it you when its done.

Saves me a job then

[MKKfish]

(1) Assuming you are going to key the result as "3-0", the cell in which you type the result will need to be formatted as text.

(2) Lets say you are using Columd D for the result and starting at Row 6.


Choose a column over to the right, say 'M' to start your formulae.

In M6 insert formula If(="3-0",5,0)
In N6 insert formula If(="2-1",4,0)
In O6 insert formula If(="1-2",1,0)
In P6 insert formula If(="0-3",0,0)  This one really redundant but included it anyway

Then in what ever cell you want the points tally displayed, assuming you want it on the same row as the match, insert formula =sum(M6:P6).

Copy down as required.

[RichEO]

Sorted it? I'll make the changes if your still stuck.

[ifm]

Sorted it? I'll make the changes if your still stuck.

Sorted, exactly as described, so grateful.