Excel COUNTIF Function for Two Conditions

This short Excel tip shows how to use Excel's COUNTIF function to count the number of data points between two values. Listed below are the various conditions, and the corresponding formulas using the COUNTIF function. The trick is simply to subtract one condition from the other.

To download a sample spreadsheet containing these COUNTIF formulas using some made-up data, click here: countif-example.xls. This example shows how the formulas can be made a little more dynamic, by concatenating the conditional operator (<, <=, >, >=, <>) with a cell reference.