View Single Post
  #1   Report Post  
OldKenGoat
 
Posts: n/a
Default How can I easily update formulas that include new rows?

I have a worksheet that I use to update league baseball game stats on a
daily basis. Each day as many as 13 new rows are added to the bottom. I then
have to go to the top of 10 separate columns one at a time to update SUM
formulas so that they will include the new rows. For example, Col C may have
a formula at the top of the col that reads: =SUM(C4:C300). After the
addition of say 9 rows, I have to manually change the formula to read:
=SUM(C4:C309). Is there a way to type that 309 in a blank cell just once and
have all the SUM formulas refer to it?

TIA for your help.
OldKenGoat