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


where E1 contains 9 and E2 21.

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