How could the value attached to a specific date falls into the corresponding month

[littleYS]

Hi guys,

I have a table where shows the 5 review dates and r5 eviewed yearly rent income for each tenant. I'm trying to pupulate the reviewed yearly rent charge into the corresponding month column (AH: CR), where list the date range by month from Apr12-Mar17. Eg. First Review Date is 01/08/2012, reviewed rent is $20,813; Second Review Date is 01/08/2013, reviewed rent is $21,645. Is there a formula that could automatically populate $20,813 under Aug-12 column and $21,645 under Aug-13 column?

Many thanks!

[John_TC]

This can be done by putting two if for calculating of review 1 is applicable, and sum of all reviews in similar way.

Sample file attached with if condition, just sum up all the similar ifs for all reviews. Also change the title of the post to [Solved] if you find it suitable.

Regards,
John
http://www.touchshoulders.com

[littleYS]

It works! Thanks heaps!