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!
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!