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

Help with formula 1
Help with formula 0
Help with formula 1
summarizing data from various workbooks 4
Looking to added up based on a character from cell range 1
I'm sure its an easy answer.... 1
Help with formula 2
Help with formula 11

Top