Array Formula: Weighted Avg with Min/Max criteria

Hi,

In cell $I$4 of the attached file, I need an array formula that will sum the calculated weighted averages of the total number of days from a given period that fall into each calander year and multiply that by the rate for each year. I may not have explained this correctectly, but basically I need a formula in cell $I$4 that returns a value that equals cell $I$6.

Any help would be greatly appreciated!

Thanks.

Thank you very much DonkeyOte! You are truely a life saver!