Seems like an easy request. I have a column of numbers of varying values. I want to count all of the values that are greater than or equal to 0 but less than 3; then, in a new cell, all of the values that are greater than or equal to 3 but less than 6; and so on.
At the bottom of the column, I put in COUNTIF(b2:b52,">=0,<3"), and the result?? Zero. Even though I can count numerous 0s, 1s, and 2s just by looking. Or else it tells me I've entered "too many arguments for this function."
How should I go about programming this???? Please help!! Thanks. SB
At the bottom of the column, I put in COUNTIF(b2:b52,">=0,<3"), and the result?? Zero. Even though I can count numerous 0s, 1s, and 2s just by looking. Or else it tells me I've entered "too many arguments for this function."
How should I go about programming this???? Please help!! Thanks. SB