Excel 2003: Sum Ranges Keep Changing When Formula Copied and Pasted

[seanof30306]

Excel 2003

I have a spreadsheet I use to track my bi-weekly budget.

Each bi-weekly contribution is laid out in the budget ahead of time in Column D.

The actual amount contributed for that period is entered in Column E.

Column F shows whether that bi-weekly period's acul contribution is more, less, or equal to that bi-weekly period's budgeted amount.

Column G is where I'm having the problem(s). Column G is where I keep a running +/- on budgeted contributions.

What I need to do on each line is add all the budgeted contributions from Column D, then subtract that total from the actual contributions in Column E to give me a cumulative +/- on contributions.

So, for example, my last contribution was on 10.21.10, which, for my Cable, was on Line 345.

So, I went up a line to Cell G344 (my previous contribution) and clicked "Copy".

Here is the formula I copied:

=SUM((SUM(E332:E344))-(SUM(D332:D344)))

I then moved the cursor down to Cell G345, right-clicked, and clicked "Paste Special" > "Formulas".

Here I hit the first problem.

As the formula is copied and pasted, it adds the new line to th formula, which is good.

The problem is, it also subtracts the first line from the formula, which is bad.

The copied and pasted formula looks like this:

=SUM((SUM(E333:E345))-(SUM(D333:D345)))

As you can see, E332 has changed to E333, and D332 has changed to D333. Each time I copy and paste the formula, I have to go back and correct those numbers. What I ned is to find a way to lock those first numbers into the formula.

There is also a second problem. Every time I copy and paste the formula, I gent that green thing in the upper left hand corner of the cell, and that exclaimation point thingie that says: "The formula in this cell refers to a range that has additional numbers adjacent to it." Each time, I have to click "Ignore Error".

Can anyone help me with these problems?

Thanks.