View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tulip Tulip is offline
external usenet poster
 
Posts: 5
Default Formula adjust for inserted row above current row

I am averaging a column of numbers =Average(A1:A33) If I insert a row
"above" A1 the formula does not adjust to include the inserted row. Is there
a way to make this work when you insert above the current row?