COUNTIF Cells in Range?
 

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!

COUNTIF Cells in Range?
 

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

"Joe" wrote in message
...
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!

COUNTIF Cells in Range?
 

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.

ToolsData AnalysisHistogram

--
Biff
Microsoft Excel MVP


"Fred Smith" wrote in message
...
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

"Joe" wrote in message
...
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!

COUNTIF Cells in Range?
 

Thanks Fred and T. That did the trick!

Joe

COUNTIF Cells in Range?
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
Thanks Fred and T. That did the trick!

Joe