Function Filter

[MarioBroshuis]

Is it possible to use more than 3 criteria in this function? I'd like to use it in wider tables (formatted as Tables) than in the examples (>8 columns) and reduce the result with 4-5 criteria so only a few rows appear for selecting purposes. Until now result shows only with a maximum of 3 criteria, 4 gives none. All criteria are coupled as =filter(Table#;(...)*(...)*(...);"")

[#2]

@MarioBroshuis 

=FILTER(A2:C11;(A2:A11="A")*((B2:B11="North")+(B2:B11="South"))*((C2:C11>600)+(C2:C11<400)))

This formula works with more than 3 criteria. As i don't know what your table looks like i can only suggest a solution for the attached example.

[#3]

=FILTER(Tabel73;(Tabel73['#Assen]=WAARDE(DEEL(D6;4;1)))*(Tabel73[AsMerk]=S5)*(Tabel73[Montage]=AK2);"Tabel73 aanvullen...")
Tabel73 has 8 colums from which I'd like to filter on 4 criteria
I work with the Dutch version: Tabel=Table, Waarde=Value, Deel=Mid

[#4]

It looks like it only accepts 3x *, adding criteria as + is possible but doesn't fit for me.

[#5]

@MarioBroshuis 

=FILTER(A2:F11;(A2:A11="A")*((B2:B11="North")+(B2:B11="South"))*((C2:C11>600)+(C2:C11<500))*(E2:E11>80)*(F2:F11="Yes")*(D2:D11>J1))

I tried with more criteria and it accepts more than 3 and ( * ) criteria.

[#6]

You are right. After I fixed a curruption in the table (contents) I previously overlooked, more than 3 criteria is no problem, also >3x *.

Thanks for your cooperation. This is one welcome function for my purpose.