Sumif/sumproduct criteria based on integer portion only

XL2010

Current formula:
SUMIF(MyRngA, A2, MyRngB)

MyRngA contains letters OR integers
A2 contains integers

I want to MyRngA to include decimals but the SUMIF to sum on the WHOLE NUMBER MATCH ONLY

Something like:
=SUMIF(INT((MyRngA), A2, MyRngB)
=SUMIF(Rounddown((MyRngA,0), A2, MyRngB)

So IF A2 contains 4, anytime cells in MyRngA contain 4, 4.1, 4.5, 4.9 etc will be included in the sum

=sumproduct(--(Int(MyRngA)= A2), MyRngB)

Doesn't work because INT() on TEXT results in an error

MyRngA contains letters OR integers

see attached example

my data are really tables but it fails without tables

=SUM(IFERROR((INT(MyRngA)= A2)*MyRngB,)) as arrayformula

The correct answer is 120

Match the integer 4 in
F5 = 4
F12 = 4.7
F19 = 4.6

G5 = 40
G12 = 40
G19 = 40

40+40+40 = 120

Tim's formula gives the correct result (ARRAY entered)

=SUM(IFERROR((INT(MyRngA)= A2)*MyRngB,))



...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

YES it does! I missed the array entry

Thanks!