COUNTIF Cells in Range?

J

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!
 
F

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top