how, num of entries in a range?

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

This looks easy, but I am having difficulty,

I have a long column of numbers.
So next to my criteria boxes,
1-5
6-10
11-15 etc.
I want the number of entries that fall in that range.

Nested if's don't work because I have way too many categories to check.
Countif need an exact match and doesn't seem to offer a range lookup.

Thanks,
crzzy1
 
One way

for 1-5

=COUNTIF(A1:A500,">=1")-COUNTIF(A1:A500,">5")

for 6-10

=COUNTIF(A1:A500,">=6")-COUNTIF(A1:A500,">10")

for 11-15

=COUNTIF(A1:A500,">=11")-COUNTIF(A1:A500,">15")

and so on
 
Back
Top