Hi and thank you all!

I have an AM table (and I have done many), but I need a command to:

1) When the End of Balance = 0, then
2) Sum all PMTs BEFORE the End of Balance = 0

I am very appreciative and would be happy to compensate any who can help.
Please see attached spreadsheet.

I'm sure the gurus here will come up with a better solution, but my advice would
be to modify the payment column, to something like:

=if(balance<=$payment,balance,$payment)

This also handles a non-standard final payment.

Now when you sum the column, all payments after the balance is paid off are
zero, and have no effect on the sum.

--
Regards,
Fred


"stewlevin" wrote in message
...
Hi and thank you all!

I have an AM table (and I have done many), but I need a command to:

1) When the End of Balance = 0, then
2) Sum all PMTs BEFORE the End of Balance = 0

I am very appreciative and would be happy to compensate any who can help.
Please see attached spreadsheet.