Hello,

Having trouble getting the formula below to work correctly. I keep getting values of #N/A.

=IF(B7:B15>6,PERCENTILE(IF(Data!$G:$G=ReportPages!$A$1,IF(Data!$E:$E=ReportPages!A7:A15,IF(Data!$I:$I>0,Data!$I:$I))),0.1),"*")
(Confirmed with Shift+Control+Enter)

Basically what I want to happen is if cell B7 has a value greater than 6, then I want the 10th Percentile of the values in column I that met both conditions contained in my IF statements. I then want this to continue on for A8, A9, A10 etc.

If I write a separate formula for each cell (A7, A8, A9, etc.) it works perfectly. The trouble is when I attempt to write a single array formula for the entire set A7:A15.

Any help would be greatly appreciated!