This can be a number, text, a cell reference or another function. =COUNTIFS(criteria_range1, criteria1,, , …)Ĭriteria range 1: This is the range that is being tested.Ĭriteria 1: The criteria to apply to the criteria range. The COUNTIFS function requires only two arguments, but can handle many more optional criteria. With the COUNTIFS function, you can count the values that meet any criteria that you specify. Along with sum and average, count is another common requirement when analyzing data. If you’re using Excel for data analysis, then this function is incredibly useful.

So, it is useful to be aware of the COUNTIF function, but COUNTIFS is far superior. However, COUNTIFS can test a single or multiple conditions.

The COUNTIF function can count values when a single condition is met. The COUNTIFS function was introduced in 2007 to be the successor to the COUNTIF function in Excel. What is the COUNTIFS function and why use it? So: let’s dive into the COUNTIFS function.

Combine text and cell references in your criteria.

Testing multiple conditions with COUNTIFS.

Testing numbers with the COUNTIFS function.

Things to consider when using the COUNTIFS function.

How to use the COUNTIFS function (step-by-step).

What is the COUNTIFS function and why use it?.

We’ll also provide a few examples of using COUNTIFS in different scenarios. In this tutorial, we’ll show you how to use the COUNTIFS function. For example, only count the orders for a specific product, or only count the exam scores where the result was 70 or higher. The COUNTIFS function is used to count only the values in a list that meet specified criteria. It is very versatile and has helped me accomplish a wide variety of tasks over the years. Whether you’re considering a career as a data analyst or just want to hone your expertise in Excel, I highly recommend that you master this function. The COUNTIFS function in Excel is one of the best functions to know.

Excel countif