countif & percentile assistance

[adam9098]

Hello,

I'm trying to get the 95th percentile of the memory utilization from the total number of occurrences of a specific server. Here is my formula but it's not giving me the desired output.

=COUNTIF(A1:AL1723,"SERVERNAME")&(PERCENTILE(O:O,0.95))

So in other words, for all of the occurrences of SERVERNAME I need to run the 95th percentile of its memory utilization which is in column O.

 

[adam9098]

figured it out for anyone who has a similar situation:


=PERCENTILE(IF('Sheet2'!A:A="SERVERNAME",'Sheet2'!O:O), 0.95)