cell ref in function formula change when inserting additional colu
 

I want to have data in column 1,2,3 and the avg in 4. when I insert a new
column before 4, I want the references in my avg function to refer to cell
2,3, 4. I am using Excel 2003 Professional

cell ref in function formula change when inserting additional colu
 

Hi!

Try this:

=AVERAGE(OFFSET(D1,,-1,,-3))

Biff

"STAR263" wrote in message
...
I want to have data in column 1,2,3 and the avg in 4. when I insert a new
column before 4, I want the references in my avg function to refer to cell
2,3, 4. I am using Excel 2003 Professional