how do you set up a spreadsheet where formulas can be prevented from updating, to be used later. Example a formula is = sum a column and store the value in say a1.
another entry later needs to have the current value in a1 as a new number is entered in the column of sums which creates an updated value. There must be a way to have a1 remain as current or someway to have that value available from somewhere else.
The problem is the average column is updated whenever new games are entered into the weekly stats. (Second sheet below)
Is there a way to preserve the average column value (AVE) somewhere after each weekly input so it can be used to calculate the hcp column and the game1hcp to game3hcp columns on the second sheet the following week.