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 1
Trailing 30 days sum calculation with excel 1
Excel Help to copy information from one row at a time to another sheet 1
Add/Subtract columns from tab to tab in same file 3
summarizing data from various workbooks 3
Help with formula 10
IF formula with multiple data range in cell 1

Top