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,