COUNTIFS Function - Excel
Overview
The COUNTIFS function in Excel is a useful tool counting the number of cells that meet multiple conditions. This functions allows you to provide multiple ranges, as long as they’re the same length, and specified conditions for each range. The final output will return the count of those that meet all of the conditions in the same position of the range.
Example:
=COUNTIFS(C2:C11, ">10", D2:D11, "run")
Syntax:
=COUNTIFS(range1, criteria1, [range2, criteria2], ...)
range1: The first range of cells you want to apply the first criteria to.
criteria1: The condition for the first range.
[range2, criteria2], ...: Optional additional ranges and criteria.
Example
In the example above, we are using the COUNTIFS function to look through two ranges, C2:C11 and D2:D11. In C2:C11 we want it to count all the numbers that are greater than 10 and in D2:D11 we want it to count all the times the word “run” appears. The COUNTIFS function will return the count of when both conditions are met in the same spot for both ranges. In this case the final output is 3 because both conditions were only met in row 3 (25 and “run”), 8 (17 and “run”), and 10 (22 and “run”).