J
Jay
I'm trying to count the number of cells which contain values within a given
range. For example, I want to count all the cell in a column which contain a
value between 50,000 and 100,000. I've tried using the Countif formula given
as an example by microsoft but the results are wrong. The formula looks like
this:
countif(y2:y268, ">=50000")-countif(y2:y268, "<=100000")
Does anyone know why I'm getting the wrong results and is there another way
to do this? Thanks
range. For example, I want to count all the cell in a column which contain a
value between 50,000 and 100,000. I've tried using the Countif formula given
as an example by microsoft but the results are wrong. The formula looks like
this:
countif(y2:y268, ">=50000")-countif(y2:y268, "<=100000")
Does anyone know why I'm getting the wrong results and is there another way
to do this? Thanks