Google Sheets formula Filter Function Problem

Dianna_S

New Member
Joined
Jul 16, 2022
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
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!


 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
How about
Excel Formula:
=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")
 
Upvote 0

Forum statistics

Threads
1,223,317
Messages
6,171,423
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top