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