I am in need of a more complicated formula. I have updated a few things in the spreadsheet, so I am attaching the new one so you can understand what I am trying to ask. I need Cell C16 in the Report tab to equal the amount of interest paid for the payment made on the "today's payment." In the Data tab that would be any time that the "Interest Accrual Account" column goes from one $0.00 to the next $0.00. For example: the payment on 11/18/2011, the interest paid would be the sum of Cell G62:G64. But if we make payments on different dates, we would need the range of the interest to also change respectively. Is there such a formula??