Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row above Sum - update formula
Use a formula of
=SUM(A1:OFFSET(A5,-1,0)) -- HTH Bob Phillips (there's no email, no snail mail, but somewhere should be gmail in my addy) "Saintsman" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Block copy/insert of 5 rows, then update formula below? | Excel Worksheet Functions | |||
Insert Row - Stop Automatic Formula Update | Excel Worksheet Functions | |||
Row insert fails to update Sum formula | Excel Programming | |||
insert or update | Excel Programming | |||
insert into a cell the last update | Excel Worksheet Functions |