List inserts auto formula with wrong range

Hi all,

I'm trying to build a simple template for pareto charts in Excel 2003. I have a list with dummy data: Item, Value, Value %, and Cumulative %, in columns B, C, D, and E, respectively.

For my Cumulative % column, each cell has the following formula (example from row 8):

=SUM(C$2:C8)/SUM(C:C)

This works beautifully when I manually enter the formula and adjust the range to include the row it's entered on. However, when I use the list's feature to automatically format the next inserted row like the previous row, the formula range "skips ahead" one row and is then broken for the new line of data.

Put another way: If I start typing at the bottom of my list in row 9, the automatically generated formula in column E has the (incorrect) range (C$2:C10) when the one above it has the (correct) range (C$2:C8).

What's going on here?

I've attached my workbook for anyone who's willing to take a look and tell me what I'm doing wrong.

Thanks in advance to anyone who can help!

-Adam Hartman
Mechanical Engineer
Flextronics Medical