1. Computing

Excel AVERAGEIFS Function Step by Step Tutorial

By

8 of 10

Entering the Criteria_range2 Argument
Entering the Criteria_range2 Argument

Entering the Criteria_range2 Argument

© 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 AVERAGEIFS 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 D3 to D9 in the worksheet to enter these cell references as the range to be searched by the function.

©2014 About.com. All rights reserved.