1. Technology
Send to a Friend via Email
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel COUNTIFS Function Step by Step Tutorial

By

1 of 9

How the COUNTIFS Function Works
Excel COUNTIFS Function Step by Step Tutorial

Excel COUNTIFS Function Step by Step Tutorial

© Ted French

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

©2014 About.com. All rights reserved.