View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
STAR263
 
Posts: n/a
Default 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