How to use the COUNTIF function

Let’s take a look.

The COUNTIF function counts cells that satisfy a single condition that you supply.

It takes two arguments: range and criteria.

Excel then returns “1,” since only one cell contains “15”.

If I temporarily enter another “15” that result will change.

you might add logical operators to the criteria.

When the criteria contains a logical operator, you’ll need to enclose it in double quotes.

you’re free to use COUNTIF with both text and numbers.

Note that COUNTIF is not case-sensitive.

you might use empty double quotes to count blanks cells.

COUNTIF also supports wildcards.

you could use COUNTIF to count dates that meet one condition as well.

This will ensure that Excel always recognizes the date correctly.

To use the DATE function, you’ll need toconcatenatethe operator and the date function together in the criteria.

Now both F15andF16 return the same result.

you’re free to also move the date out onto the worksheet where it can be easily changed.

Again, you’ll need to concatenate the operator with the cell reference.