SumIf - SOLVED

Hi,

Thanks in advance to all who help.

I would like to turn the key functionality of my sheet in yellow into a VBA function. In essence I want the program to scan a bunch of dates and pick the correct rent for each month. Then total the rent for the year. The rents change in different month increments. I have accomplished my goal with some formulas but it is not practical for me to use this in actual work. I would like to automate what I have created in a formula AND only show the year end total.

See attachment.

Thanks.