Thanks for your help.

It seems to be working.
--
Floridaguy


"Gord Dibben" wrote:

Enter this formula in Column A below your payments or a cell like C1

=SUM(A1:INDEX(A:A,ROW()-1))

If you insert a row in column A and add a value, the formula will adjust to
include that new value.


Gord Dibben MS Excel MVP


On Wed, 31 Oct 2007 12:01:18 -0700, Floridaguy
wrote:

I'm new to Excel and am still learning. I am working in Excel 2000. What I've
done is make up a spreadsheet for my checking account which, is working quite
fine except for a little problem that I have been experiencing.

Sometimes I post payments and deposits in advance. For example I may make a
posting for a November payment and am still in the month of October. Now that
I have entered the Nov payment and, then want to add another row to put in an
October payment, I find that the balance is incorrect and, the only way to
try and correct it is to copy the previous balance and paste it. However, my
continuing balance remains incorrect.

In short, what I am trying to do is to insert rows before payments that have
already been entered and, at the same time maintain the correct balance.

Will appreciate any suggestions.

Thanks