View Single Post
  #1   Report Post  
coo-too
 
Posts: n/a
Default 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!