Simpler way to record the outcomes of matches

[Newman100]

I recently posted work of my attempts to create a league table, i feel i have probaly chosen the worst way to record the actual results of matches, causing the need for complicated formula which donkyoite has been very helpful in doing and i thank him, but i dont understand whats going on, was wondering if there was a simplier way? My work is posted below, would be very grateful for suggestions.

[shg]

Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

[Newman100]

lol sorry mate, i read the rule its just that is what my problem is, il change it though, hope you feel its correct.

[martindwilson]

put each score in its own cell.which i think donkeyote advised.
so it looks like this

[Newman100]

Ahh i see, probally very easy to do but im being stupid, how do you get the Team 1 bit to cover cells b and c?

[martindwilson]

put "team 1" in b ,select b an c. on tool bar select format/cells/alignment/in the horizontal box scroll down to centre across selection click ok
ps never did rate tony adams lol

[Newman100]

ok i have done that but now im back to my original problem i have no idea how to code the results of the games to produce a table of points, i,e when a team has more goals the team gets 3 points, 0 for losing and 1 for a draw.

[DonkeyOte]

To be honest the simplest approach of all is to add the results in tabular form (list) ... eg:

Col A: Home Team
Col B: Home Goals
Col C: Away Goals
Col D: Away Team

You can if you want a Matrix view populate it from the above listing(s).

Even if you enter the scores into separate cells in matrix form you will still be left with relatively complex Sumproduct formulae to do the aggregation.

(P.S. You can never trust a gooner).

[Newman100]

I dont understand what you mean by that, were do i put the colum to say which team is playing which :S

[DonkeyOte]

See sheet2 -- attached file -- this is how I would advise you record your results... subsequent calcs utilise more basic approaches (and are more efficient).

[martindwilson]

then just coz i couldnt sleep combine both! and still enter scores on sheet 1