I'm trying to determine a certain percentile of an array of numbers using an PERCENTILE function. However, I only want to include certain numbers within this array in the calculation. The numbers I want to include all have the same value in an adjacent column, so I'm thinking I can do something similar to a SUMIF where the adjacent column will be checked to see if the correct value is present before the number is added to the array. Is there a way I can accomplish this within a PERCENTILE function? Thanks in advance for any assistance.