I would like to lock reference to cells (not the value in the cell) and prevent that from changing regardless if I insert, delete, or move the column/row/value.

Example (see attached spreadsheet)
B3 calculates the sum of the last four months of sales, C3:F3 (Jan - April). Next month I will enter May's sales and want B3 to still sum up the last four months (so Jan will not be part of the calculation but the new May will).

At this point, when I insert a new column before C to post the May sales data, B3 changes reference to D3:G3.

Is there a way to lock the reference to C3:F3 regardless of what happens to those cells?

Thanks.

Attached Files

a.xls (64.0 KB, 11 views)