cell ref in function formula change when inserting additional colu

[Guest]

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

 

[Biff]

Hi!

Try this:

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

Biff