Making Excell formula constant
 

i have got a sum of figures of column b i row a29as a formula in a29 my
formula is "=b27"

when i insert a column between a and b my formula chagnes to
"=c27"
I want my formula to be constant.

Making Excell formula constant
 

=SUM(INDIRECT("B2"):B4)
=indirect("b2")
--
Don Guillett
SalesAid Software

"darsg" wrote in message
...
i have got a sum of figures of column b i row a29as a formula in a29 my
formula is "=b27"

when i insert a column between a and b my formula chagnes to
"=c27"
I want my formula to be constant.

Making Excell formula constant
 

Try typing this formula instead

=$B$27

"darsg" wrote:

i have got a sum of figures of column b i row a29as a formula in a29 my
formula is "=b27"

when i insert a column between a and b my formula chagnes to
"=c27"
I want my formula to be constant.

Making Excell formula constant
 

In additon to Don's suggestion, you can use this formula in A29

=OFFSET(A29,-2,1)

That will be unaffected by column inserts

"darsg" wrote:

i have got a sum of figures of column b i row a29as a formula in a29 my
formula is "=b27"

when i insert a column between a and b my formula chagnes to
"=c27"
I want my formula to be constant.