How to Count Cells Defined by a Percentile

greasebucket

New member
Local time
Today, 10:25
Joined
Oct 23, 2008
Messages
2
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, I think the command to do this should be:

=COUNTIF(E2:BB2,">(PERCENTILE(E2:BB9,0.9))")

When I use this command, there is no error with the command, but all of the values turn out to be zero.

Any tips on correcting this apparently incorrect formula?

Thanks Much!
 
Does this work?

=COUNTIF(E2:BB2,">"&(PERCENTILE(E2:BB9,0.9)))
 
yes, it works!
thanks VERY MUCH for your suggestion!!
 

Users who are viewing this thread

Back
Top Bottom