Thanks, it took a while to "translate" your formula into the template I had
already modified to suit my needs but, it WORKED!!!
--
J.


"Roger Govier" wrote:

Hi Joyce

One way would be to add a column I called Cleared balance.
Click on the column header for column H to select it, click the Format
painter icon, then click column I, and that will get the appearance the
same.
In cell I6 enter =H6
In cell I7 enter =$I$6-SUMPRODUCT(--($E$7:E7="x"),--($F$7:F7-$G$7:G7))
and copy down.
Then, if you put an x in column E (Labelled "C"), then column I will
reflect the cleared balance down to that transaction.

--
Regards

Roger Govier


"Joyce" wrote in message
...
I like the Checkbook register template for basic use, too. Does anyone
know
how to add a formula to the column named "C" so that cleared checks
can be
checked off and my checkbook can be balanced automatically?
--
J.


"JM Hazel" wrote:

I just started using the Checkbook register template and love it.
Until I
need to add some more rows, now the addition and subtraction feature
in the
Balance column doesn't work.
What did I do wrong?
How can I continue to put information in added rows and continue to
get the
Balance feature to work.
Thanks for your help
--
JM Hazel