Hi Lorne,

See the attached sheet. H2 of Master Inventory sheet shows 12 which is correct ... or do you need some other result there?

Inventory and Sales_v1.0.xlsx

Regards,
DILIPandey
<click on below * if this helps>