SUMIF Range in Range

Question

I'm trying to sum only if a value from a collection is in a set list of values.

I've tried using a SUMIFbut it keeps returning 0.

Given:

and

and

I've Tried:

=SUM(SUMIF(M7:M10,X2:X4,H7:H10))

But it's returning 0 each time. How can I modify this to correctly SUMIF

Answer 1

Or just use SUMPRODUCT()

=SUMPRODUCT(SUMIFS(H:H,M:M,X2:X4))