Weighted average calculation

I want to calculate the weighted average in terest rate for deposits considering the following variables: 
 - Deposit amount;
 - Interest Rate; and 
 - activation date

The table below is showing the result i got using sumproduct function in excel.