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?

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?