Use the Absolute reference to the range:
=SUMPRODUCT(($A$1:$A$8=$A10)*($B$1:$D$8))

The $ before one part of the address means it is an absolute reference and
will not change when copied. In the $A10 shown above, the $A column will
remain constant but the 10 (Row) will move + or - as you copy the formula up
or down. HTH.