| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fina number of records between 2 percentile values
How do i find the number of test scores between the 50th and 75th percentile?
Formula using now is =countif(data cells in range, "<=" &value of 75th percentile) -countif(data cells in range, "" &value of 50th percentile) -number of records -1 Thanks in advance! |
|
#2
|
|||
|
|||
|
=SUMPRODUCT((B1:B10=50%)*(B1:B10<=75%))
"coo-too" wrote: How do i find the number of test scores between the 50th and 75th percentile? Formula using now is =countif(data cells in range, "<=" &value of 75th percentile) -countif(data cells in range, "" &value of 50th percentile) -number of records -1 Thanks in advance! |
|
#3
|
|||
|
|||
|
One way:
=COUNTIF(rng,"<="&PERCENTILE(rng,0.75)) - COUNTIF(rng,"<"&PERCENTILE(rng,0.5)) alternatively: =SUMPRODUCT(--(rng<=PERCENTILE(rng,0.75)), --(rng=PERCENTILE(rng,0.5))) In article , "coo-too" wrote: How do i find the number of test scores between the 50th and 75th percentile? Formula using now is =countif(data cells in range, "<=" &value of 75th percentile) -countif(data cells in range, "" &value of 50th percentile) -number of records -1 Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| How can I get Positive values only from the random number generat. | Excel Discussion (Misc queries) | |||
| Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| Finding the max of a column where values less than a specified number | Excel Worksheet Functions | |||
Linear Mode
