Forum Discussion
Solved
I am sure I am looking for IF command advice, but not 100% sure
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)...
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)
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)
