Try this ARRAY formula. Confirm with Control+Shift+Enter

=SUM(IF(ISNUMBER(B1:B26),(B1:B26),0)*ISNUMBER(MATCH(A1:A26,E3:E7,0)))