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

Excel AVERAGEIFS Function Step by Step Tutorial

By

10 of 10

Adding the Search Criteria and Completing the Tutorial
Adding the Search Criteria

Adding the Search Criteria

© Ted French

Adding the Search Criteria and Completing the Tutorial

The last step in the tutorial is to add data to the cells in the worksheet identified as containing the Criteria arguments.

Tutorial Steps

For help with this example see the image above.

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

  2. In cell D12 type >250 and press the Enter key on the keyboard (the " > " is the symbol for greater than in Excel) .

  3. The answer $74,220 should appear in cell E13.

  4. Only two records those in rows 4 and 5 match both criteria and, therefore, only the sales totals for those two records are averaged.

  5. The average of $70,702 and $77,738 is $74,220.

  6. When you click on cell E12, the complete function
    =AVERAGEIFS (E3:E9, C3:C9, C12, D3:D9, D12) appears in the formula bar above the worksheet.

©2014 About.com. All rights reserved.