• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

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
0
jayfletcher
Asked:
jayfletcher
  • 2
1 Solution
 
redmondbCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now