"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
|