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.