The COUNTIF Function in Excel 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 (range, criteria)  
  • range – The range of cells to count.
  • criteria – The specified criteria from which the cells should be counted.

CountIf – Single criteria example

*It is vital to add the parenthesis surrounding your criteria

Countif Function

CountIf – Single number criteria 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 logical operators. Here a couple that are commonly used.

“>”  “<” “=”


The COUNTIF function in Excel is an excellent tool to know. This function can be nested within other functions to better analyze data. has an excellent tutorial on using the COUNTIF Function with a nested Average Function. They also demonstrate how to combine multiple COUNTIF Functions.

Leave a Reply

DATEDIF Function

The DATEDIF Function in Excel is used to calculate the number of days, months, or years between two dates. A

Read More »

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »
Scroll to Top