Countifs Function in Excel – Multiple Criteria

Countifs Function in Excel with Multiple Criteria

The countifs Function is used when you want to count data with multiple criteria. See how how to use the countifs function with multiple criteria.

CountIfs

*It is vital to add the parenthesis surrounding your criteria. Pay attention to the placement.

In the below example, we use the countifs function to first look for “Blue” in the A column and only count if the number in column B is greater than 4.

Was this article helpful?

Related Articles

Leave a Reply