Hello, I'm a relative nOOb to Excel.

I'm going to be maintaining stats for a cricket league.

Its goingto be:

Column A: Name, B: Games played, C: Runs(points)scored, D: Highest
score etc...

Now, my problem is, since there are 168 players, and they'll be playing
around 16 games each whole season, I need to add up their stats
end-of-season as easily as possible.

I could use simple SUM(C1+C2+C3+...Cn) for the total runs and all, but
doing it individually for each player would take long, plus each player
wont be playing the same number of games , so i'd have to alter the
formula to add up for each one...

Is there a simpler way, preferabely that would enable the added up
stats to appear on sheet 2 ? And could it be easy enough to allow me to
update easily after every game ?


--
neonw
------------------------------------------------------------------------
neonw's Profile: http://www.excelforum.com/member.php...o&userid=29129
View this thread: http://www.excelforum.com/showthread...hreadid=501329