Sort, filter formula returning error?

[valmir]

Hi Everyone! I have this formula that works fine: =SORT(FILTER(A5:B536;C5:C536="X");1;-1)
Now, I'm trying to add one more criteria and I thought this one would do: =SORT(FILTER(A5:B536;(C5:C536="X")+(C5:C536="Y");1;-1)
Basically, I am trying to get the results returning not only "X" as in the first formula, but also "Y"
I'm getting a "too many arguments" error!

 

[Peter_SSs]

In the second one you have lost the closing parenthesis for the FILTER function

=SORT(FILTER(A5:B536;(C5:C536="X")+(C5:C536="Y"));1;-1)

 

[valmir]

In the second one you have lost the closing parenthesis for the FILTER function

=SORT(FILTER(A5:B536;(C5:C536="X")+(C5:C536="Y")

Thanks a lot. It worked! ???

 

[Peter_SSs]

You're welcome. Glad to help.