| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
get a count of numbers whose value falls within a given range
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. |
|
#2
|
|||
|
|||
|
=COUNTIF(range,""&4)-COUNTIF(range,""&17)
For example: =COUNTIF(C24:C29,""&2)-COUNTIF(C24:C29,""&5) Regards Trevor "LyleB_Austin" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
try
=countif(Range,"<=17")-Countif(range,"4") "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. |
|
#4
|
|||
|
|||
|
=countif(A1:A100,"4)-countif(A1:A100,"17)
or =SUMPRODUCT(--(A1:A1004),--(A1:A100<=17)) Regards Ken..................... "LyleB_Austin" wrote in message ... 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. |
|
#5
|
|||
|
|||
|
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. |
|
#6
|
|||
|
|||
|
actually <=
I'm glad you caught it. "LyleB_Austin" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count occurence of numbers separated by , in a single cell | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| count cells with unique numbers | Excel Worksheet Functions | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Hybrid Mode
