Let me know the formula of calculate (how many quantity sold in nos) in sheet1 in cloumns D2 (mark in red).

My master sheet is sheet name: MIDC
in columns m : partno is thier & in columns n : qty
in MIDC sheet partnos repeated reflected.

I want formula in sheet1 in location D2 (respecting cloumns a2) : Calulation of qty.

Please confirm.