Excel Help

Log in to stop seeing adverts
This page may contain links to companies such as eBay and Amazon. As an affiliate of these sites I may earn commission if you click the link and make a purchase

Status
Not open for further replies.
M17TT C said:
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 :)
Click to expand...
Nice.
 
Thanks, I feel I've proudly earnt another geek stripe today :)
 
Status
Not open for further replies.
Log in to stop seeing adverts

P Pld Pts
1Liverpool1536
2Chelsea1634
3Arsenal1733
4Nottm F1731
5Aston Villa1728
6Manchester C  1727
7Newcastle1726
8Bournemouth1625
9Brighton1725
10Fulham1624
11Tottenham 1623
12Brentford1723
13Manchester U1622
14West Ham1720
15Palace1716
16Everton1515
17Leicester1614
18Ipswich1712
19Wolves169
20Southampton165

Latest posts

Back
Top