Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula Auto-Adjustment
Hello,
I have a formula that references cells on another worksheet (say sheet1). The formula looks like this: =sum(sheet1:A1:A8) When I remove two rows (row 2 and row 3) from sheet1, the formula is adjusted automatically to: =sum(sheet1:A1:A6) However, this is not what I want. How do I keep the original formula sum(sheet1:A1:A8) even if rows are deleted? I tried sum(sheet1:$A$1:$A%8), but to no avail. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value Axis Adjustment | Excel Worksheet Functions | |||
Using Cell Data as adjustment to formula references | Excel Worksheet Functions | |||
Formula Adjustment? | Excel Worksheet Functions | |||
formula adjustment | Excel Worksheet Functions | |||
Formula Adjustment - Help | Excel Worksheet Functions |