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.
This thread is now locked and can not be replied to.
How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…
1995-2015: How technology has changed the world in 20 years
Alex Chinneck’s giant ice cube Christmas tree at Kings Cross
Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.