How the COUNTIFS Function Works
Related Tutorial: Text only version - Excel COUNTIFS Function
COUNTIFS extends the usefulness of the COUNTIF function by allowing you to specify from 2 to 127 criteria rather than just one as in COUNTIF.
COUNTIFS looks for specific criteria in two or more fields in the record and only if it finds a match for each field specified is the record counted.
COUNTIFS Function Step by Step Tutorial
In the COUNTIF step by step tutorial we matched the single criterion of sales agents who had sold more than 250 orders in a year.
In this tutorial we will set a second condition using COUNTIFS - that of sales agents in the East sales region who made more than 250 sales in the past year.
Setting additional conditions is done by specifying additional Criteria_range and Criteria arguments for COUNTIFS.Following the steps in the tutorial topics below walks you through creating and using the COUNTIFS function seen in the image above.