Skip to content

Explore the COUNTIFS Function

In one of our previous articles, we showed you how to use the COUNTIF function. In this article, we will go into how to use the COUNTIFS function.

The COUNTIFS Function

The COUNTIFS function allows you to count the cells in a spreadsheet based on many criteria instead of just a single condition like the COUNTIF function.

This means that you can evaluate multiple criteria on multiple ranges. The catch is that the ranges must be of equal size.

This is due to how the COUNTIFS function works.

How the COUNTIFS Function Works

The COUNTIFS function requires two arguments for each criterion you wish to apply to your count. This means that the function needs at least two arguments to start with and can have an unlimited number of arguments but only in increments of two. 2…4…6…8…etc.

Then for each criterion, the first argument is the range you wish to evaluate, and the second argument is the criterion you are testing for.

=COUNTIFS(range_1, criteria_1, range_2, criteria_2)

The COUNTIFS function will go through the range and count each cell that matches the criterion.

The COUNTIFS function will repeat this process for the next set of two arguments and the next two and the next two until it has gone through them all.

 

The last part of how this function works is the most important.

The COUNTIFS function does not return a count of the individual cells that met the single criterion.

 

Instead, the COUNTIFS function returns a count of the rows containing cells that all meet the test condition.

How to Use the COUNTIFS Function

To use the COUNTIFS Function, you need at least two arguments as mentioned before. The first argument is the range of cells you want the function to analyze. The second argument is the criteria you are checking.

=COUNTIFS(range, criteria)

You can also have more arguments to test more conditions, but you must add two arguments at a time.

Here is an example. In the image below, there are three ranges to evaluate.

 

In the first range, you will test for the text value “Blue”.

In the second range, you will test for a numerical value greater than two.

In the third range, you will test for a Boolean value (true/false value) of FALSE.

The final formula is shown below. This formula is placed in cell C8.

=COUNTIFS(A2:A7,"Blue",B2:B7,">2",C2:C7,FALSE)

 

The final count results in a value of one because only one row contains cells that all match the criteria.

 

And that is how to use the COUNTIFS function.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top