Google Sheets formula Filter Function Problem

[Dianna_S]

I have a problem, I used Filter Function to pull certain columns to a inventory total item. But I want to have an IF function with it because on the Outgoing Tab there as an input error(Outgoing Tab) that should be not counted on the Inventory Total Item.

Conditions:
Unit Expected: The Item That is pulled out
Units Received: The items that is on hand/On inventory
The Error cause: The item pulled out is much more compared on the Units Received.

For Example: FBA16YF6QQ on Bath Tray should not be counted on the Filter Function because on the Outgoing tab it has an "Input Error" I hope I explained it well. Thank you for the help!

VA Knowledge (Inventory System) Ebson Bautista.xlsx

Task CREATE A COPY. Do NOT edit directly on here as I am having a few VAs work on this Hello I created this task which should be easy and quick. I just want to see if we can work together and your level of knowledge is good for us. We have a warehouse and we need to know how much inventory is ...

docs.google.com

 

[Fluff]

How about

=FILTER({Outgoing!$C:$C,Outgoing!$A:$A,Outgoing!$I:$I,Outgoing!$F:$F,Outgoing!$P:$P,Outgoing!$H:$H},Outgoing!$F:$F="Apple Valley",Outgoing!$N:$N="Bath Tray",Outgoing!$O:$O<>"Input Error")