I'm trying to streamline a spreadsheet I do for a fantasy basebal
league, and if there's a way to do the following, that would be great:

We run our games on weekends and base our point system on how th
actual players perform.

I have a weekly stat section, and a season to date stat section (STD
awkward acronym, I know).

I would like to be able to make the STD section automatically update a
I enter the weekly stats (adding each new week's stats to the tota
from the previous weeks), rather than having to actually do the variou
additions manually.

I'm pretty sure the above is possible (I just don't know how to do it)
but I also need to have the values in the STD section remain the sam
when I reset each week to 0 without having it revert to 0 as well (i.e
after each weekend the STD value locks as the initial value to add th
new week's stats to).

Any help would be appreciated, and if I wasn't clear on anything, jus
ask and I'll clarify


-
bigjimfb
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message550603.htm