Maybe there is a call for sumproduct =SUMPRODUCT((Sheet1!H2:H20)*(Sheet1!A2:H20=A2))

Remember for sumproduct (although Bob can disprove this probably) you ranges span the same rows, so if you change the above formula to say H100 then you must do it for both sides of the formula.