| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Keeping one part of a formula same, but change other cell ref?
How do I keep one part of a cell formula the same, but change the other
referenced cell? Example: =sum(D2/D9) where D9 stays the same, but D2 will change to D3, D4, etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
| Part Number/Qty Consolidations | Excel Discussion (Misc queries) | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| Why does a formula change when I sort a column | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Threaded Mode
