View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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!