Hi PPT,

See JE McGimpsey's Cell Accumulator page at:

http://www.mcgimpsey.com/excel/accumulator.html

---
Regards,
Norman


"PPT" wrote in message
. ..
can someone please tell me how i can create a formula where the total is
always changing

think of the hockey standing, if a team wins they would get 2 points and
their total increases by 2....then they win again so their total increase
again based on the new total

is there a formula i can use to just enter the points a person accumilates
that day and it will automatically give me a new overall total,