Take Percentile if between certain date range

I'd like to take the 90th Percentile of the test scores (Column B) that fall between a certain date range (Column A).

Example: Take 90th percentile of scores that fall between 12/30/2015 and 12/27/2015
Dates (A) Scores (B)
12/31/2015 95
12/30/2015 96
12/29/2015 71
12/28/2015 82
12/27/2015 77
12/26/2015 61

I (unsuccessfully) came up with: =PERCENTILE(IF(A:A>DATEVALUE("12/27/2015"),IF(A:A<DATEVALUE("12/30/2014"),IF(B:B<>"",B:B))),0.9)

FOR THE LOVE OF GOD HELP ME

Try to limit your ranges and yjis is array formula type, so you need to press CTRL+SHIFT+ENTER button all together, ENTER alone don't works

=PERCENTILE(IF($A$2:$A$7>=DATEVALUE("2015/12/27"),IF($A$2:$A$7<=DATEVALUE("2015/12/30"),$B$2:$B$7)),0.9)

Rizky said:

Try to limit your ranges and yjis is array formula type, so you need to press CTRL+SHIFT+ENTER button all together, ENTER alone don't works

=PERCENTILE(IF($A$2:$A$7>=DATEVALUE("2015/12/27"),IF($A$2:$A$7<=DATEVALUE("2015/12/30"),$B$2:$B$7)),0.9)

Click to expand...

It worked! Thank you kind stranger.

Rizky said:

Try to limit your ranges and yjis is array formula type, so you need to press CTRL+SHIFT+ENTER button all together, ENTER alone don't works

=PERCENTILE(IF($A$2:$A$7>=DATEVALUE("2015/12/27"),IF($A$2:$A$7<=DATEVALUE("2015/12/30"),$B$2:$B$7)),0.9)

Click to expand...

If we need to add one more criteria for "Name" how the formula will be?

akshank said:

If we need to add one more criteria for "Name" how the formula will be?

Click to expand...

If the names are in column C then:
=PERCENTILE(IF($A$2:$A$7>=DATEVALUE("2015/12/27"),IF($A$2:$A$7<=DATEVALUE("2015/12/30"),IF($C$2:$C$7="John",$B$2:$B$7))),0.9)

Not sure about Google sheets, you're not really in the right place.