COUNTIF >= <

  • Thread starter Thread starter Shawn Dorsey
  • Start date Start date
S

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.
 
"Countif" only takes one condition. However, you can try this:-

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