Fina number of records between 2 percentile values

Jonathan Cooper

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Preceding a number by zeros, that is still a number	Michele	Excel Worksheet Functions	1	September 14th 05 01:06 PM
How can I get Positive values only from the random number generat.	Markw3700	Excel Discussion (Misc queries)	1	January 21st 05 12:37 AM
Is there a way to have two values (percent and number) in a label.	msmiller613	Charts and Charting in Excel	1	December 15th 04 03:47 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Finding the max of a column where values less than a specified number	Mark Silka	Excel Worksheet Functions	1	November 17th 04 03:14 PM

All times are GMT +1. The time now is 07:18 AM.

Menu

About Us