Sumif to Sumproduct

Hi there,

Would really appreciate some help with this. . .

I have this sum if formula

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

And am trying to make it into a sumproduct formual that does the same thing as I have learnt that sumif s do not auto update other sheets if they are not open! whereas sumproducts do.

Would anybody be able to help me convert this as I am not very familiar with the ins and outs of sum Products.

Thanks for your help!!