Thread: COUNTIF issues

Hey people,
I'm currently trying to break up my data into ranges e.g. 101 to 200

And heres my formula

 =COUNTIF(milestone1a!E7:E126,"<=101 AND >=200")

The problem im having is its saying there's 0 so im not to sure.

Greatful for any help, thanks

Assume you need to count between >=101 AND <=200

If you are on XL 2007 or late use COUNTIFS like,

=COUNTIFS(milestone1a!E7:E126,">=101",milestone1a!E7:E126,"<=200")

Or,

The following formulas will work with any versions.

Use COUNTIF like,

=COUNTIF(milestone1a!E7:E126,">=101")-COUNTIF(milestone1a!E7:E126,">200")

=SUM(COUNTIF(milestone1a!E7:E126,">"&{100,200})*{1,-1})

Can you please the formula you tried? How's the range formatted? If the range formatted or numbers entered as text this wouldn't work.

Try this. Select the range go to Data >> Text to columns then click Finish. What is the answer you getting now?

The range i am doing is 201 - 300 so i literally just changed the 101 and 200 from the last formula as the countif range is the same so im using;

=COUNTIFS(milestone1a!E7:E126,">=201",milestone1a!E7:E126,"<=300")

I did like you said but nothing changed, but the when i did 101 to 200 it works yet by changing the figures, it doesn't like it.