Large(if(and with 3 arguments on an array

[suwbacca]

Hello everyone,

I am trying to get the top 10 largest values in column E based on 3 arguments in column A, B and C. I tried the following for my top 1 for example:

=LARGE(IF(AND(A:A="All",B:B<>"Other",C:C="All"),E:E),1)

If I just press Enter, I get the #1 value of the entire column E (66.216), without qualifying for the 3 arguments. If I press Ctrl+Shift+Enter, I get 0.

Can I not use IF AND on an array ? If not, what would be the way to do it ?

Thanks in advance !

Susanne