get a count of numbers whose value falls within a given range

LyleB_Austin

Posts: n/a

Thanks all. BJ, your response was essentially correct except that the
needs to be < in the second 'countif' expression.

"LyleB_Austin" wrote:

I have a series of numbers in a column. What I want to do is find out how
many of the numbers fall within a given range. For example, let's say I have
20 random numbers. I want to find out how many of the 20 are 4 and <=17.

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
how to count occurence of numbers separated by , in a single cell	kish20	Excel Worksheet Functions	3	June 10th 05 07:49 AM
Match Last Occurrence of two numbers and Count to Previous Occurence	Sam via OfficeKB.com	Excel Worksheet Functions	33	April 4th 05 02:17 PM
Count and Sum Total occurrances of two specific numbers	Sam via OfficeKB.com	Excel Worksheet Functions	10	March 29th 05 08:13 PM
count cells with unique numbers	Alex	Excel Worksheet Functions	1	February 21st 05 07:46 PM
count a group of numbers but do not count duplicates	Lisaml	Excel Worksheet Functions	2	January 26th 05 11:19 PM

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

Menu

About Us