View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mopechicken Mopechicken is offline
external usenet poster
 
Posts: 2
Default formula to sum the prior 12 cells regardless of added columns?

I need to sum the preceding 12 cells in a row within excel - regardless of
the fact that some columns will be added in front of this cell with the
formula. I want the formula to "float" just not sure how to accomplish it?