| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update all formulas on spreadsheet - Apr05! to May05! | Excel Discussion (Misc queries) | |||
| When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) | |||
| Excel formulas are slow to update | Excel Worksheet Functions | |||
| specific rounding of formulas which may need to include an IF stat | Excel Worksheet Functions | |||
| copy worksheet ... formulas do not update | Excel Worksheet Functions | |||
Threaded Mode
