Excel allows you to do named ranges. Select a range, then type its name in the address box. Then, in another cell, you can type =sum(myrange).
if you use insert row - then formulas respond and will go from C2:C10 to C2:C11 (tested in excel2003 at least)