I have a large raw data table and want to calculate the percentile of a group of records which meet a number of criteria (5 to be precise).

Example of what I've been trying (it's returning a value error):

=percentile(if(and(rawdata[criteriacolumnA]="this criteria", rawdata[criteriacolumnB]="this criteria"), rawdata[columnwithdataforpercentilecalculation], "") 0.025)

Any idea what I'm missing? Sorry for the sketchy example however I feel like the solution is something simple so I don't want to invest in making a sample notebook just yet.

Thanks in advance,

Max