COUNTIF >= <

[Shawn Dorsey]

I would like to be able to count the number of occurrences
of a values between say greater than or equal to 200 and
less than 300 in a range of say 250 rows.

I have tried =countif(B1:B251,">=200<300") and it returned
a zero even though I could values between 200 and 300.

I am using Excel 2000. Please let me know if any further
info is required.

 

[Max]

Use 2 COUNTIFs

: =COUNTIF(B1:B251,">="&200)-COUNTIF(B1:B251,"<"&300)

 

[Eddy]

"Countif" only takes one condition. However, you can try this:-

=COUNTIF(B1:B251,">=5")-COUNTIF(B1:B251,">=300")