Hello everyone

I need little help for solving a small problem. below worksheet is out of our Bill of Material formula, if we want to produce a Product '55500' we will need input 500,510,520,530,7600.

7600 is our WIP which also has input 10,20,30,40. i need a formula in next column which add OUTPUT number like in column TEST

OUTPUT INPUT TEST
55500 500 7600
55500 510 7600
55500 520 7600
55500 530 7600
55500 7600 7600
7600 10 55500
7600 20 55500
7600 30 55500
7600 40 55500