I'm not quite sure of what you mean when you say you get a "repeating Sum".
Where is your SUM formula, and what does it look like?

If it looks like =SUM($I$2:$I$4) (just as an example), then it will retain
those same cell references as you copy it down the sheet. If it looked like
=SUM(I2:I4) the row numbers would change as it is copied down the sheet.

"Mark C" wrote:

I am in the process of developing a general ledger spreadsheet for my church.
The spreadsheet shows a list of the different funds in the church and I am
using a formula: =IF(AND(ISBLANK(F5),ISBLANK(G5)),"",H4+(-F5)+G5) for the
balance column of each fund. My problem is when I try to fill in the
"Summary of
Accounts" that utilizes a SUM of all paid and SUM of all received monies, I
get a repeating Sum in the spreadsheet when I copy the formula down. I would
be grateful for any help.
Mark Christjansen