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