Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically update formula (sum) when inserting row Cheri D. Excel Discussion (Misc queries) 2 October 19th 06 07:53 PM
cell ref in function formula change when inserting additional colu STAR263 Excel Worksheet Functions 1 May 18th 06 11:04 PM
How can a formula in a cell automatically update when inserting a. stbookkeeper Excel Worksheet Functions 1 June 23rd 05 08:14 PM
Auto Update upon shifting, inserting or deleting Tracy B Excel Worksheet Functions 2 April 6th 05 08:37 PM
Auto update entire columns / rows??? Kcurtis Excel Worksheet Functions 3 February 3rd 05 11:45 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"