Thread: auto update formula when inserting additional columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default auto update formula when inserting additional columns
=SUM(G1:INDEX(1:1,COLUMN()-1)) entered in M1


Gord Dibben MS Excel MVP


On Thu, 9 Aug 2007 06:58:03 -0700, dlisman
wrote:

Formula covers columns G thru L = formula in column M Ex. =Sum(G1:L1)
Insert columns M thur S -- formula now in column T Ex. should read
=Sum(G1:S1)
Column T Formula will not automatically update to include columns M thru S

Version Excel 2003

Reply With QuoteReply With Quote