On Nov 16, 10:23*am, via sarpi wrote:
Hi, I have the following numbers, about 4 real estate projects (named
A, B, C, D). For each of them, there is a lease contract, and the rent
changes according to a "start date" and an "end date".
But since I need to sum the rent paid in each year, I need for each
project the sum of rent paid in that specific year, considering the
rent amount can change during the year.
*In the example below, project A would pay 2 months of first due rent
in year 2011, then in 2012 it will pay for 10 months the same rent,
and then the new rent for the next 2 months, and so on.
How to do these total?
thanks

Projects START * * * * *END * * * * * * * * * * ANNUAl RENT
A * * * 01/11/2011 * * *31/10/2012 * * * 1.800.000
A * * * 01/11/2012 * * *31/10/2013 * * * 2.200.000
A * * * 01/11/2013 * * *31/10/2014 * * * 2.300.000
A * * * 01/11/2014 * * *30/12/2021 * * * 2.800.000
B * * * 01/01/2012 * * *30/09/2013 * * * 1.800.000
B * * * 01/10/2013 * * *30/12/2021 * * * 3.600.000
C * * * 01/11/2011 * * *30/12/2021 * * * 2.600.000
D * * * 01/01/2012 * * *31/12/2013 * * * 2.000.000
D * * * 01/01/2014 * * *31/12/2015 * * * 2.400.000
D * * * 01/01/2016 * * *30/12/2021 * * * 2.800.000

Your question needs better clarification.