Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi JE,
Thanks for this it worked... appreciate the help Cheers "JE McGimpsey" wrote: Try: A1: =SUM(OFFSET(A1,1,0,ROW(A4)-ROW(A1)-1,1)) A4: =SUM(OFFSET(A4,1,0,ROW(A8)-ROW(A4)-1,1)) In article , Andy B wrote: hI JE, I have tried the formula but it doesn't seem to work. I'm not sure but the A6-1 caputures the values in cell A5. I just want the formula in A1 to capture the amounts in A2:A3, and if someone were to add a row below the A3 row it would the new A4 the formula in A1 will read sum(A2:A4). Thereafter the formula in the A4 cell prior to the insert would would move down. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
Insert Row & Copy Formula | Excel Worksheet Functions | |||
Copy & Insert from another xls | Excel Discussion (Misc queries) | |||
Automatically insert row and copy formula | Excel Worksheet Functions | |||
Insert Formula and Copy to other cells | Excel Discussion (Misc queries) |