Another way (without the need of CSE):

=IFERROR(SUMPRODUCT((Sheet1!$A$5:$A$9='Results Sheet'!$H$1)*(Sheet1!$B$5:$B$9='Results Sheet'!$H3)*Sheet1!$C$5:$C$9),"")

Place in 'Results Sheet'!I3