Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Automatically update formula (sum) when inserting row

I have very simple spreadsheet with 5 columns. Last cell in each column is
sum of cells above it using =SUM. I thought the formula would update
automatically when I insert rows so that the new row cell would be added to
the sum but this isn't happening. Automatic calculation is checked. What
else do I need to do?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Automatically update formula (sum) when inserting row

Enter formula in column A then drag across to column E.

=SUM(A1:INDEX(A:A,ROW()-1))


Gord Dibben MS Excel MVP


On Thu, 19 Oct 2006 11:38:02 -0700, Cheri D. <Cheri
wrote:

I have very simple spreadsheet with 5 columns. Last cell in each column is
sum of cells above it using =SUM. I thought the formula would update
automatically when I insert rows so that the new row cell would be added to
the sum but this isn't happening. Automatic calculation is checked. What
else do I need to do?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Automatically update formula (sum) when inserting row

Cheri,

If you're adding a row between the cell with the SUM in it and the last row
of the cells being summed, SUM won't catch it because it's outside the range
of the SUM function. For example, if you are summing cells A10:A17, and the
SUM function is in cell A18, and you try to insert a row between A17 an A18,
SUM won't update to include it. If you try to insert a row between A16 and
A17, SUM will include it. The same applies for the top of the range.


"Cheri D." wrote:

I have very simple spreadsheet with 5 columns. Last cell in each column is
sum of cells above it using =SUM. I thought the formula would update
automatically when I insert rows so that the new row cell would be added to
the sum but this isn't happening. Automatic calculation is checked. What
else do I need to do?

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
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Copying formula with cell reference decreasing automatically mworth01 Excel Discussion (Misc queries) 8 April 21st 06 08:59 PM
Cell Ref. in Formula changes automatically knighthawk Excel Worksheet Functions 1 February 21st 06 02:02 AM
How can a formula in a cell automatically update when inserting a. stbookkeeper Excel Worksheet Functions 1 June 23rd 05 08:14 PM
Can I set up the formula to update automatically? pugsly8422 Excel Worksheet Functions 1 March 23rd 05 05:43 PM


All times are GMT +1. The time now is 04:09 PM.

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"