Search results

yes, it works! thanks VERY MUCH for your suggestion!!

I'm having trouble nesting COUNTIF and PERCENTILE formulas. I want to count the number of cells in a row that exceed a threshold level that I define using the PERCENTILE function. If I want to count all the cells from E2 to BB2 that exceed the 90th Percentile of all of the values from E2 to BB9...