MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COUNTIF function with "between" condition


Posted by Ana Guiu on January 16, 2002 10:34 AM

I want to use the COUNTIF function, but my condition is a number within a range (e.g., greater than 9 but less than 21). Can this be done?


Posted by Aladin Akyurek on January 16, 2002 10:50 AM

Ana --

=COUNTIF(A2:A10,">"&E1)-COUNTIF(A2:A10,">="&E2)

where E1 contains 9 and E2 21.

PS. This message board is searchable. Even just CONTROL+F can be of use.

Aladin