Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.


COUNTIFS is used to counts the cells that contain numbers that comply with more than one condition at the same time.
In our example, we’ll be counting how many cells contain a number larger than 10, as well as have the letter A on their row in column B.

The function needs two ranges, and two conditions. So we’ll type in the function, select the area, and type in our first condition, which is “larger than 10”. We’ll then select the second area, and type in the second condition, which is the letter “A”.

We are shown that there are only 2 cells which contain numbers larger than 10, and have the letter A in column B.
In this lesson we have gone through the COUNTIFS function