COUNTIFS Function

When to use it?

Use this function when you want to count items in a range based on a set of criteria.

Syntax

= COUNTIFS (Range_1, Criteria_1, [Range_2], [Criteria_2],... )

• Range is the list values you want to test for a criteria.
• Criteria is the criteria to test.