Insert Column

Shonky · Mar 7th, 2002, 04:00 AM

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)?

Mar 7th, 2002, 04:21 AM

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

Anne Troy · Mar 7th, 2002, 04:30 AM

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

Mar 7th, 2002, 04:30 AM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	You can also use named ranges for the cells that you're summing instead of the absolute refs. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 04:00 AM	#1
Shonky New Member Join Date: Feb 2002 Location: Australia Posts: 41	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)?

Mar 7th, 2002, 04:21 AM	#2
Guest Posts: n/a	=SUM(INDIRECT("B1"):INDIRECT("D1"))