Using Sumproduct to calculate weighted average

So I have a bond portfolio made up of bond funds and treasuries. I have broken out for the bond funds what portion of their portfolios are attributable to Government bonds, Corporate bonds, Asset backed bonds etc. Now each bond obviously makes up a certain weight in the portfolio. What I'm trying to do is calculate the weighted average percentage of Government bonds, Corporate bonds, Asset backed bonds etc for the entire portfolio based on each bond funds weighting in the portfolio. I've attached what I have so far, I just would like to know if I've done it correctly or if I'm missing something. Any help in clarifying this would be greatly appreciated The column "N" is where I have the weighted average calculation that I need help with.

Cheers!

Hi,

You need to change relative reference to absolute - see attached file.

Ah I missed that! Thank you guys for the help!