Insert Column

[Shonky]

I there anyway to insert a column and not have a formula change.

Ie I have a formula that says sum all of the values from $B$1 to $D$1. If I then insert a column at column B, the forumla changes to sum($C$1:$E$1). Can I get this to stay as sum($B$1:$D$1)?

 

[Guest]

=SUM(INDIRECT("B1"):INDIRECT("D1"))

 

[Anne Troy]

You can also use named ranges for the cells that you're summing instead of the absolute refs.