1. Computing

Excel COUNTIFS Function Step by Step Tutorial

By

7 of 9

Entering the Criteria_range2 Argument
Excel COUNTIFS Function Step by Step Tutorial

Excel COUNTIFS Function Step by Step Tutorial

© Ted French

Entering the Criteria_range2 Argument

As mentioned previously, in this tutorial we are trying to match two criteria in each data record:

  1. Sales agents from the East sales region.
  2. Sales agents who have made more than 250 sales this year.

The Criteria_range2 argument indicates the range of cells the COUNTIFS is to search when trying to match the second criteria - sales agents who have sold more than 250 orders this year.

Tutorial Steps

For help with these instructions, click on the image above.

  1. In the dialog box, click on the Criteria_range2 line.

  2. Drag select cells E3 to E9 in the worksheet to enter these cell references as the second range to be searched by the function.
  1. About.com
  2. Computing
  3. Spreadsheets
  4. Excel How To Videos
  5. Excel COUNTIFS Function Step by Step Tutorial

©2014 About.com. All rights reserved.