Help with formula

R

Richard

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!!
 
J

JMB

you could try
=IF(B3="","",MAX(B3-SUMIF('Sent to Assembly'!A:A,A3,'Sent to Assembly'!B:B),
0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top