| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell range in Excel
How do I get the cell range in a formula to automatically increment when I
add a new row? For example, if the formula is =SUM(C3:C8), how do I get the second cell to change to C9 when I add a new row? |
|
#2
|
|||
|
|||
|
See:
http://www.contextures.com/xlNames01.html#Dynamic -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Joe Sadusky" <Joe wrote in message ... How do I get the cell range in a formula to automatically increment when I add a new row? For example, if the formula is =SUM(C3:C8), how do I get the second cell to change to C9 when I add a new row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
