Filter Formula W/ 3 Criteria (Leaving Blank will populate all)

[FiggyDad]

Okay, let me try and explain... I have a sheet that lists asset assignments, there are three criteria I'm working with, user type, user status and device type. The user type would include Staff, Student, Room. The user status would include Active or Inactive. And the device type would include laptop, chromebook, ipad, etc... I have drop down lists to select what you want to filter, but I also want the ability to include ALL results if I delete any of those criteria.

Here is the current formula I have that has TWO criteria, and it works if I delete one of those two, both of them, it will populate everything as intended. But as soon as I add a third criteria, for user status, it breaks the formula.

Formula w/ 2 (Working):
=IFERROR(FILTER(AMTAGS[Assignment],IF(B3<>"",AMTAGS[Assignment Type]=B3,AMTAGS[Assignment Type]<>"")*IF(B5<>"",AMTAGS[Product Type]=B5,AMTAGS[Product Type]<>"")),"")

Formula w/ 3 (Not Working):
=IFERROR(FILTER(AMTAGS[Assignment],IF(B3<>"",AMTAGS[Assignment Type]=B3,AMTAGS[Assignment Type]<>"")*IF(B4<>"",AMTAGS[Staff Status]=B4,AMTAGS[Staff Status]<>"")*IF(B5<>"",AMTAGS[Product Type]=B5,AMTAGS[Product Type]<>"")),"")

Can anyone please help me to figure out what is going wrong?

 

[StephenCrump]

But as soon as I add a third criteria, for user status, it breaks the formula.

It's not clear what "breaks the formula" means. And your screenshot doesn't match your description.

Can you please explain in more detail, preferably providing an example to illustrate, using XL2BB - Excel Range to BBCode

By the way, this construction: IF(B3<>"",AMTAGS[Assignment Type]=B3,AMTAGS[Assignment Type]<>"") is filtering only non-blanks. If you want all values, including blanks, returned when no filter is specified, you could simplify your formula to:

=FILTER(AMTAGS[Assignment],IF(B3="",1,AMTAGS[Assignment Type]=B3)*IF(B5="",1,AMTAGS[Product Type]=B5)*IF(B4="",1,AMTAGS[Staff Status]=B4),"")

 

[FiggyDad]

Stephen, your correction and simplification fixed it. Thank you so much!