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