ExcelBanter - Fina number of records between 2 percentile values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Fina number of records between 2 percentile values (https://www.excelbanter.com/excel-discussion-misc-queries/48376-fina-number-records-between-2-percentile-values.html)

coo-too

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!

Jonathan Cooper

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

JE McGimpsey

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!

All times are GMT +1. The time now is 11:16 AM.