I am sure I am looking for IF command advice, but not 100% sure

[Matt_QC]

Hello all!

I am looking for assistance to find the right formula. Hoping someone can help out.

Thank you in advance!

IF Column E (in form 1) = Column D (in form 2), then Column K (in form 1) with the row it matched in Colum E (form 1) & Column D (form 2) - Column K (in form 2) with the row it matched in Column E (form 1) & D Column (form 2)

This would need to stack - IF Multiples in Form 2, then subtract all from Form 1.

I hope this makes sense...

Basically trying to subtract the Original Lot# Qty in receiving inspection from any lot#'s released that matches the Original lot# in receiving to see how much inventory is left.

[#2 · Accepted solution]

@Matt_QC You need to use the SUMIF function. The formula would look like this:

In the cell in Form 1 where it says FORMULA, and let's assume this is M11 and that the sheet that contains Form 2 is called "Form2".

=K11-SUMIF(Form2!D:D,E11,Form2!K:K)

[#3]

@Riny_van_Eekelen 

Thank you very much. That worked flawlessly!