Auto calculate components from a table

[auburnfan03]

Untitledpicture.png

I am trying to figure out how to autosum components with multiple lines. For example if I input 1 in A2,B2,C2,&D2, I want the individual components needed from the list below to tally up so I know the totals needed on the production list.

I assume it is a SUMIF or a HLOOKUP but I cannot figure it out.

Thanks so much in advance!

[vlady]

Moderator's note:

Please refrain from uploading pictures that needs formula entries ( other members can't open pictures due to firewalls etc.)

If you will post that workbook may i also suggest that you put some sample expected outputs

Regards,
Vladimir