I can see the spreadsheet mate, but I have no idea of what to do. The cell
L212 refers to F21, what exactly should it be calculating.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Whizz" wrote in message
...
Here you go:

http://www.megaupload.com/?d=27CUS14C

If you scroll down to H211 you'll see my league table but I haven't a clue
how to live update it so that when I update the players scores it updates
the
manager's league table.

Thanks for your help

"Bob Phillips" wrote:

Sample data might help, but it just sounds like SUMIF

=SUMIF(A1:A100,"Team A",B1:B100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Whizz" wrote in message
...
I'm running a fantasy football league at work and i'm updating it via
excel.
The system requires you to add points for each player in each team and
a
total is calculated. I would then like to create a league table to
show
which
team is leading... it needs to update as I enter in the new points for
each
player. I know it's really simple but I can't for the life of me
remember
how
to do it.