Formulae depend on data and required calculations so we need much more detail
to answer your questions.

"Simon P" wrote:

I'm about to run a fantasy sports league, id like to do it on excel. just
wondering if there was a way of linking everyones team with there players, so
that when i update players individual scores, the team scores are also
updated. What formulas would i need to use etc.