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