Percentile with multiple conditions

[pastels]

How can you use the percentile function with two conditions? I need to find let say the 90th percentile of test scores for Male students from the state of New York.

 

[Domenic]

Assuming that Column A contains the gender, such as Male, Column B contains the state, such as New York, and Column C contains the test scores, try...

=PERCENTILE(IF(A1:A10="Male",IF(B1:B10="New York",IF(C1:C10<>"",C1:C10))),0.9)

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the range accordingly.

Hope this helps!

 

[pastels]

Thanks Domenic! I was messing around with Sumproduct but couldn't get it work. This one is perfect!