Hoping for some help yet again! I have a detailed list of balances and am I trying to summarize the information to calculate the weighted average based on country. I'm using SUMPRODUCT to calculate the weighted average but I do not know how to incorporate an IF statement to only pick up certain balances. Attached is my example and formula attempt.

Thank you in advance!
Book6.xlsx