1. Computing

Excel AVERAGEIF Function Step by Step Tutorial

By

8 of 8

Adding the Search Criteria
Adding the Search Criteria

Adding the Search Criteria

© Ted French

Adding the Search Criteria

The last step in the tutorial is to add the criteria we want the function to match.

In this case we want to find the average yearly sales for sales reps in the East region so we will add the term East to D12 - the cell identified in the function as containing the criteria argument.

Tutorial Steps

For help with this example click on the image above.

  1. In cell D12 type East and press the Enter key on the keyboard.

  2. The answer $59,641 should appear in cell E12. Since the criterion of equaling East is met in four cells (C3 to C6) the numbers in the corresponding cells in column E (E3 to E6)are averaged.

  3. When you click on cell E12, the complete function
    = AVERAGEIF (C3:C9, D12, E3:E9) appears in the formula bar above the worksheet.

  4. To find the sales average for other sales regions, type the name of the region, such as North in cell E12 and press the Enter key on the keyboard.

  5. The average for that sales region should appear in cell E12.

©2014 About.com. All rights reserved.