Hey,

I use Excel to run my own Fantasy Football competition with a few mates. I have all of the players listed with their current points total next to their names and then each of the Fantasy teams with the workbooks linked with formulae so that I dont have to enter the points for each player into each team. I just do it once.

For example, if John Smith scores 5 points and he is already on 100 points then I simply use my head and add 5 to 100 and re-enter the points. But it would be alot easier if there was some function that I could use that will allow me to just type in the points he scored in that game and it adds it to the total, or adds it to the previous number in the cell (e.g. if the cell says 100 and I type 5 it changes it to 105).

Thanks for any tips in advance

Christof