• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel COUNTIFS Function Step by Step Tutorial

#### 1 of 9

How the COUNTIFS Function Works

Excel COUNTIFS Function Step by Step Tutorial

### How the COUNTIFS Function Works

Related Tutorial: Text only version - Excel COUNTIFS Function

Excel's COUNTIFS function can be used to count up the number of data records in a selected range that match specific criteria.

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.

Normally, COUNTIFS works with rows of data called records. In a record, the data in each cell or field in the row is related - such as a company's name, address and phone number.

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.

Tutorial Topics

Ted French