Thread: Rolling 12 moth formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
  
Posts: 460
Default Rolling 12 moth formula
I would like to create a formula in Col A that would go out 12 columns (B -
M) and then be able to insert a new column B and have the formula remain
=Sum(B1:M1) and not change to =Sum(C1:N1). Is that possible?
Reply With QuoteReply With Quote