"Billy Liddel" wrote:

Parts related_to packages items/pack Stock Shortf/Over
Girders 10 10 0
Bolts Girders 2 10 20 10
Nuts Girders 1 10 10 0
Hoses 5 5 0
Nozzles Hoses 2 2 -3

Formula in E1; =IF(ISBLANK(D2),C2,C2*D2)
Formula in F1:

=SUMPRODUCT(--($A$2:$A$6=A2),($B$2:$B$6"")*($E$2:$E$6))-SUMPRODUCT(--($A$2:$A$6=B2)*($E$2:$E$6))

Hopes this helps

Where should I send my first born?! Thanks!

Maury