SUMIF with multiple conditions + Wildcard in Name

Hi All,

Can you help generate excel formula to get sum the money with the 4 conditions?

I'm trying wildcard for the countries in column H to do condition #2 but no luck.

excel help 4.png

in H2

=SUMPRODUCT(($B$2:$B$15)*($D$2:$D$15=$H2)*(--LEFT($C$2:$C$15,1)>=1)*(--LEFT($C$2:$C$15,1)<=7))

Names in H must match those in D

Cell I2 formula

HTML Code: