Nice.Persistance is the key!
If anyone is still interested then the correct answer is:
=SUM(OFFSET(A2,0,COUNTA(2:2)-7,1,7))
And if anyone wants to play about with the sheet to see it working, feel free to have a look.
Thanks again though for everyones time, help and input
| P | Pld | Pts | |
| 1 | Liverpool | 23 | 56 |
| 2 | Arsenal | 24 | 50 |
| 3 | Nottm F | 24 | 47 |
| 4 | Chelsea | 24 | 43 |
| 5 | Manchester C | 24 | 41 |
| 6 | Newcastle | 24 | 41 |
| 7 | Bournemouth | 24 | 40 |
| 8 | Aston Villa | 24 | 37 |
| 9 | Fulham | 24 | 36 |
| 10 | Brighton | 24 | 34 |
| 11 | Brentford | 24 | 31 |
| 12 | Palace | 24 | 30 |
| 13 | Manchester U | 24 | 29 |
| 14 | Tottenham | 24 | 27 |
| 15 | West Ham | 24 | 27 |
| 16 | Everton | 23 | 26 |
| 17 | Wolves | 24 | 19 |
| 18 | Leicester | 24 | 17 |
| 19 | Ipswich | 24 | 16 |
| 20 | Southampton | 24 | 9 |
