I'm using this formula to track how many parts are sent to assy in C3.
=IF(B3="","",SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B)). What
I'm trying to do is take the results from this formula and subtract the
results from B3. But once it reaches or excedes the qty needed in B3 show "0"
or "Order Complete". Thanks in advance!!