auto update formula when inserting additional columns
 

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

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