View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default "Relative" Absolute Cell References in Excel 2007

Try:

=SUM(INDIRECT("D2:F2"))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


wrote in message
...
I have a worksheet that has a formula which uses absolute cell
references ($D$2:$F$2). If I insert a new column to the left of
Column D the "absolute" references change to ($E$2:$G$2).

What I want is to add data to the new column and have the formula
calculate on the original ($D$2:$F$2) range. Rather than changing the
formula every time I do this (and copying it down several hundred
rows) is there a way to get around this 'feature' and have the
absolute reference stay absolute?

Thanks for any insight,

Theoden