percentile if and statement

[bill9898989]

Hello,

I have data with multiple columns. In one column I have months designated 1 - 12 (column C). In another column I have values such as temperature (column P). I am trying to calculate the 85th percentile of only the months may - October (5 - 10). I have tried a nested percentile if and statement but am getting it incorrect.

={PERCENTILE.INC(IF(AND(C3:C254920>=5,C3:C254920<=10),P$3:P$254920,""),0.85)}

It returns #VALUE!

Can someone help me with this? I'd really appreciate it, thank you.

 

[MarcelBeug]

Try replacing AND with multiplication, like (out of my head):
=PERCENTILE.INC(IF((C3:C254920>=5)*(C3:C254920<=10),P$3:P$254920,""),0.85)

 

[bill9898989]

That worked! thank you very much