Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Have a question on scrolling sum with Excel.
Have a question on scrolling sum with Excel.
For example: Insert function into cell D4=SUM(A4:C4) then insert a row in front of A, the function in E4 will turn into SUM(B4:D4) how to do if I wanna keep the function not changed |
#2
|
|||
|
|||
Try this:
=SUM(INDIRECT("A4:C4")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "A question on scrolling sum" <A question on scrolling wrote in message ... Have a question on scrolling sum with Excel. For example: Insert function into cell D4=SUM(A4:C4) then insert a row in front of A, the function in E4 will turn into SUM(B4:D4) how to do if I wanna keep the function not changed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Question regarding a strange condition in Excel spdsht... | Excel Discussion (Misc queries) | |||
Need your expertise!! Excel Question | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Have a question on scrolling sum with Excel. | Excel Worksheet Functions |