COUNTIF Cells in Range?

[Joe]

I have a column of numbers (93, 96, 97, 76, 87, 97, 100, etc.) I need a
formula that will populate how many cells have numbers falling between 65-75,
another formula showing cells between 76-89.

Just for clarification, this is not a SUM of the data. It is a count of
cells that fall between a given range.

Displaying the number of cells below 65 was easy (=COUNTIF(C4:C29,"<=65")).
Displaying the number of cells 90 and above (=COUNTIF(C4:C29,">=89")). It's
the ranges in between that have me stumped.

I know this is not the formula, but what I need is =COUNTIF(C4:C29,"cells
with numbers between 65 and 75")

I am sure this is easy, but I cannot seem to find it.

Thanks!

 

[Fred Smith]

65 and below: =COUNTIF(C4:C29,"<=65")
Above 65 to 75: =COUNTIF(C4:C29,"<=75")-COUNTIF(C4:C29,"<=65")
Above 75 to 90: =COUNTIF(C4:C29,"<=90")-COUNTIF(C4:C29,"<=75")
Above 90: =COUNTIF(C4:C29,">90")

Regards,
Fred

 

[T. Valko]

Another one...

List these bin levels:

E4 = 65
E5 = 75
E6 = 90
E7 = 90+

Select the range F4:F7

Array enter** :

=FREQUENCY(C4:C29,E4:E6)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Or, you can setup a histogram which will do the same thing as above without
having to enter a formula.

Tools>Data Analysis>Histogram

 

[Joe]

Thanks Fred and T. That did the trick!

Joe

 

[T. Valko]

You're welcome. Thanks for the feedback!