COUNTIF issues

[dannyshezo]

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

And heres my formula

Please Login or Register  to view this content.

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

Greatful for any help, thanks

[Haseeb Avarakkan]

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})

[dannyshezo]

Thanks, seems to be working now, only issue i have is that i ammended the formula to suit another range and now its displaying 0 for that range,

Thanks for your help

[Haseeb Avarakkan]

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?

[dannyshezo]

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;

Please Login or Register  to view this content.

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.