Hi,
I'm trying to update a league table spreadsheet with a running total of points for each team. I've got a countif function counting the number of games, but obviously that will change as the season goes on. I want to make the cell with the countif result "Freeze" so it can't be changed.

For instance, after game 1, cell a2 will contain "teamname1" as a countif on number of games. After game 2, cell a2 will change to be "teamname2" because an extra game will have been played. I want to freeze cell a2 after the first game so I can then do a lookup on that in the running total after each game.

Sorry if this sounds complicated. I can provide the spreadsheet if required to show what I'm trying to do. Any help would be appreciated. Thanks.