Google sheet filter function

[Giovannicavuccio]

Hi guys, a silly question: is it possible to make it so that if I leave the cells with conditions empty, that condition is not counted? Let me explain better:

K	L	M	N	O
Player	Gender	Expertise	Weekday	Hours
=filter function	M	Beginner	Monedy	PM

Right now, if for example I leave cell O8, which would be Hours blank the formula shows me ‘Player not found’ Instead, I would like to be shown all the player that got the other 3 conditions without caring about Hours. At the moment, I have tried to structure it like this, but it works fine only with gender (F/M) cause are only two options, but for the level and availability, things change. Could you help me?

=IFNA(FILTER(Names!A3:A1001;Names!E3:E1001=M8; (IF(L8=”"; (Names!B3:B1001=“M”)+(Names!B3:B1001=“F”); Names!B3:B1001=L8));((Names!I3:I1001=N8) + (Names!G3:G1001=N8) + (Names!H3:H1001=N8) + (Names!F3:F1001=N8) + (Names!F3:F1001=“Every day”)); (Names!J3:J1001=O8));“Player not found”)

I also tried to maybe put in the condition of the levels instead of

Names!E3:E1001=M8

this

if(M8=“”;TRUE;Names!E3:E1001=M8)

but it doesn’t work the same, could you help me? Thank you

 

[RoryA]

You should be able to use something like:

(Names!B3:B1001=L8)+(L8="")