Hi smilking.

Try this.

=sumproduct(('Production Input'!$B$6:$B$309,=$D1)*('Production Input'!$J$6:$J$309))

Hope to helps you.