Countif Function in Excel – Single Criteria

Countif Function Overview

The countif Function is extremely useful when dealing with large data sets. Here is a basic example of house to use this function. Below we are trying to count how many times “blue” appears in the list.

CountIf – Single criterea example

*It is vital to add the parenthesis surrounding your criteria

Count If Function Excel

CountIf – Single number criterea with logic

*It is vital to add the parenthesis surrounding your criteria

In this example, we use the countif function to count how many numbers in the range are greater than “4”

You can swap out “>” for several other options. Here a couple that are commonly used.

“>”

“<”

“=”

Count If Function Excel

Was this article helpful?

Related Articles

Leave a Reply