Comment by amobilebiz

You don't have to trick it in Excel 2003. If you have 10 rows (i.e. c1 thru c10) and in c11 you have the sum if you right click on row 11 and insert row it will insert a row above 11 and update your formula for you in c11 to include the new row.