Find number of times a number occurs between a certain range.

I have a colunm of numbers and i want to find the amount of times a numbers occurs.

Example:

I wnat to find how many times a number between 16 and 16.5 occurs in a column
jayfletcherAsked:
Who is Participating?
 
redmondbConnect With a Mentor Commented:
jayfletcher,

Assuming that the cells to be counted are in column A, the following will give you the answer...

=COUNT(A:A)-COUNTIF(A:A,"<16")-COUNTIF(A:A,">16.5")

The above assumes 16 to 16.5 inclusive. If you want it exclusive then...

=COUNT(A:A)-COUNTIF(A:A,"<=16")-COUNTIF(A:A,">=16.5")

Regards,
Brian.
0
 
jayfletcherAuthor Commented:
thanks
0
 
redmondbCommented:
And to you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.