Thread: Keeping Cells Stationary in Formula's

When I use a cell's value as a part of formula, and then move the cell, Excel (conveniently) adapts the column/row info in the formula. How do I keep it from doing this?

For example: Every week, I add new columns to my worksheet, however I have a formula that keeps track of values over the past two months. Left to it's own clever devices, Excel would continue to base the formula on those same original two months, so I have to continually go through and make sure that "=SUM(E2:E10)" doesn't creep down to "(E3:E11)", "(E4:E12), etc.

How do I tell Excel that I want "=SUM(E2:E10)" even if I add columns (or rows)?

GN

=SUM(INDIRECT("E2:E10"))