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
There are currently 1 users browsing this thread. (0 members and 1 guests)