binaryman101
asked on
Need an excel formula
I am still working on the project from my last question. I would like a formula that will allow me to have sum the payments made during any given year so I have a Payments YTD on the report. I need it will automatically populate in the Report tab when i make changes in the "Data" tab. The document is attached.
Copy-of-Amortization-on-a-Simple.xls
Copy-of-Amortization-on-a-Simple.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked well, but now 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??
Copy-of-Amortization-on-a-Simple.xls
Copy-of-Amortization-on-a-Simple.xls
ASKER
awesome thanks
SUMIFS(Data!C16:C11015,Dat
You would have to update the dates each year.