| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUm function and adding rows
Is there a way to get the SUM function to increase the range if a row is
added right above the previous SUM range. FOr example to go from SUM(C3, C22) to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM function resides. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUm function and adding rows
You could use a formula like this in C23:
=SUM(C2:OFFSET(C23,-1,0)) FredZack wrote: Is there a way to get the SUM function to increase the range if a row is added right above the previous SUM range. FOr example to go from SUM(C3, C22) to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM function resides. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding rows to the data array used in an Index function | Excel Discussion (Misc queries) | |||
| Adding rows based on no of rows specified from a given position | Excel Worksheet Functions | |||
| Function on dynamicly adding rows in column | Excel Worksheet Functions | |||
| Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
| Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions | |||
Hybrid Mode
