Entering the Criteria Argument
Although actual data - such as the word East can be entered into the dialog box for this argument it is usually best to add the data to a cell in the worksheet and then enter that cell reference into the dialog box.
For help with these instructions, click on the image above.
- Click on the Criteria line in the dialog box.
- Click on cell D12 to enter that cell reference. The function will search the range selected in the previous step for data that matches this criteria.
- The search term (East) will be added to cell D12 in the last step of the tutorial.
Cell References Increase Function Versatility
If a cell reference, such as D12, is entered as the Criteria Argument, the AVERAGE IF function will look for matches to whatever data has been typed into that cell in the worksheet.So after finding the average sales for the East region it will be easy to find the average sales for another sales region simply by changing East to North or West. The function will automatically update and display the new result.