Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula changes while inserting a row !!!!
Hi,
My worksheet looks like this. In A2 = 3 In A3 = 4 In A1 = Sum(A2:A3) If I insert a row in between A1 and A2, the formula in A1 changes to "=sum(A3:A4)", whereas I want it to show, "=sum(A2:A4)". How can I do this ??? Regards, Joseph |
#2
|
|||
|
|||
Try...
=SUM(INDIRECT("A2"):A3) Hope this helps! In article , "Sanjeev Unnikrishnan" wrote: Hi, My worksheet looks like this. In A2 = 3 In A3 = 4 In A1 = Sum(A2:A3) If I insert a row in between A1 and A2, the formula in A1 changes to "=sum(A3:A4)", whereas I want it to show, "=sum(A2:A4)". How can I do this ??? Regards, Joseph |
#3
|
|||
|
|||
try this
=SUM(INDIRECT("A2:A"&ROW(A3))) -- Don Guillett SalesAid Software "Sanjeev Unnikrishnan" wrote in message ... Hi, My worksheet looks like this. In A2 = 3 In A3 = 4 In A1 = Sum(A2:A3) If I insert a row in between A1 and A2, the formula in A1 changes to "=sum(A3:A4)", whereas I want it to show, "=sum(A2:A4)". How can I do this ??? Regards, Joseph |
#4
|
|||
|
|||
Thanks !!! It works !!!
"Domenic" wrote: Try... =SUM(INDIRECT("A2"):A3) Hope this helps! In article , "Sanjeev Unnikrishnan" wrote: Hi, My worksheet looks like this. In A2 = 3 In A3 = 4 In A1 = Sum(A2:A3) If I insert a row in between A1 and A2, the formula in A1 changes to "=sum(A3:A4)", whereas I want it to show, "=sum(A2:A4)". How can I do this ??? Regards, Joseph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden Columns are unhidden when inserting a Formula | Excel Discussion (Misc queries) | |||
Inserting a Space in The Same Place Formula | Excel Worksheet Functions | |||
formula a1=b1+c1 inserting column after a1 changes formula a1=c1. | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Inserting row but with formula carried down | Excel Worksheet Functions |