I would have a total (say =C3:C54) in cell C55. Then your frozen cell would be =C55.
As you add rows your total in C55 would increase to accommodate the extra rows and your frozen cell formula will change as well.
Hands-on: Acer Predator Triton 700 review
D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year
How to lose weight with an Apple Watch
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.