Posted to microsoft.public.excel.programming

Saintsman

external usenet poster

Posts: 81

Insert row above Sum - update formula

Row value
A1 12
A2 10
A3 6
A4 4
A5 Sum(A1:A4) = 32

I want to insert a row above row 5, but the sum function needs to change to
Sum(A1:A5).
Any ideas

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Block copy/insert of 5 rows, then update formula below?	David	Excel Worksheet Functions	2	October 15th 08 05:35 PM
Insert Row - Stop Automatic Formula Update	Kevin	Excel Worksheet Functions	1	July 8th 08 10:09 AM
Row insert fails to update Sum formula	quartz[_2_]	Excel Programming	6	April 3rd 05 10:59 PM
insert or update	Laurent M	Excel Programming	2	February 2nd 05 10:21 AM
insert into a cell the last update	Ramiro Cubillan	Excel Worksheet Functions	1	December 29th 04 08:45 PM

All times are GMT +1. The time now is 02:27 AM.

About Us

"It's about Microsoft Excel"