Help with IF and SUMPRODUCT to calculate weighted average??

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

Consulttk,

Your formula should be like this:

=SUMPRODUCT(($A$4:$A$7=$A12)*($C$4:$C$7)*($D$4:$D$7))/SUMIF($A$4:$A$7,$A12,$C$4:$C$7)

Note: The ranges above directly relate to the ranges in your example workbook.
$A$4:$A$7 = range containing Region names
$A12 = range containing "USA"
$C$4:$C$7 = range containing Interest Inc values
$D$4:$D$7 = range containing 30-day Yield values

I tested against both examples (USA & Europe) and got the correct results as you manually calculated.

Enjoy.

This is awesome, I never would have figured that out! Thank you so much!