I taught myself to do basic formulas with Excel (IE, started typing things that sounded good till it worked), and have done up a basic spreadsheet for Warhammer Fantasy Battles armies. What im trying to do is allow myself to add a row, and have the row automaticly fill itself in with a basic Formula

IE E4 contains =Sum(C4*D4). When I add a row under row 4 (Becomming row 5, and pushing the old row 5 to row 6, which edits its formulas automaticly), I want it to automaticly fill the new E5 position with =Sum(C5*D5).

Somehow I had that working at first, but I remade the thing a few days latter with a couple extra formulas floating around, It never worked in the new version.