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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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.
> >
> >
> >