View Single Post
  #3   Report Post  
bj
 
Posts: n/a
Default

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.