Percentile of x if y is between A and B

[mnemosign]

Hi there,

I am trying to use Excel to produce box plots using the Percentile function. Let's say I have two arrays Yij and Xij. The idea is to find the median (50th percentile) of the y variable only if the x variable is between A and B. (where y and x are arrays of the same dimensions. Once the median of the y values when x is between A and B is found, the same formula can be used to find the Min,25,75,Max percentiles to create the box plots. Then I can compare the box plots to see if there is a difference between groups when the value of the factor varies. It looks like this:

To produce this plot, I use a formula like this:
=percentile(if(A1:E5>=ValueA, if(A1:E5<ValueB,G1:K5)),k)

Let's say my X array is A1:E5 and Y array is G1:K5 - two matrices with the same dimensions. I am seeking a way to find the k percentile of Y when X is between A and B. However I am not sure if the Percentile function works this way with arrays in Excel. Let me know if my approach is correct or if you have any alternate ideas of how I can do this.