• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel AVERAGEIFS Function Step by Step Tutorial

#### 10 of 10

Adding the Search Criteria and Completing the Tutorial

### 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.

Ted French