Lock my Formula when deleting columns

[lordfa9]

Lets say I have this simple formula

SUM($C1:$E1)
..
..
..
SUM($C100:$E100)

lets say I delete column C and insert a new column directly after what used to be the former column E, the formula will now change to SUM($C1:$D1)

Is there any way to lock the formula so that it will ALWAYS be C1:E1? No matter what I do with the columns in between?

[Special-K]

Maybe try

=SUM(INDIRECT("C!&ROW()&":E"&ROW()))