hi
i am trying and have been for most of the weekend to write a formula to enable me to find the total points gained per team per week played as a running total either home or away. I have attached a sample spreadsheet (test.xls) Spreadsheet contains two sheets: Data and League.
i have tried IF functions, Vlookups etc to no avail.
Basically what i am struggling with is, if for example Arsenal played 16th August and won i would like this to appear in the approiate cell (B3) on the 'league' sheet as 3pts. Then, they played again on 23rd August and drew. In the apporpiate cell (B6) on the 'league' sheet should read 4pts (3pts from previous and 1 pt for drawing.)
I hope people can understand that waffle.
Thanks in advance,
Bookmarks