Post #2 formulas are Array formulas. Need to confirm these using Control+Shift+Enter_Not just enter.

Also in I1.

=SUMIF(Sheet1!A5:A9,'Results Sheet'!H1,Sheet1!E5:E9)