| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making graphs in excell | Excel Discussion (Misc queries) | |||
| Making a CSV from several collumns in excell | Excel Discussion (Misc queries) | |||
| making variables constant | Excel Worksheet Functions | |||
| making a column of formuls constant | Excel Worksheet Functions | |||
| making calculated fields constant. | Excel Worksheet Functions | |||
Linear Mode
