I was recently asked how to use the COUNTIF function to count the number of values in an array that are between two numbers, such as num1 < x <= num2. It can be pretty simple if you use two COUNTIF functions and subtract the results. Examples can be found on the following page, along with a demo spreadsheet.

Excel COUNTIF Function for Two Conditions