Entering the Criteria1 Argument
In this tutorial the first criteria we are looking to match is if data in the range C3:C9 equals East.
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 Criteria1 line in the dialog box.
- Click on cell C12 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 C12 in the last step of the tutorial.
Cell References Increase Function Versatility
If a cell reference, such as C12, is entered as the Criteria Argument, the AVERAGEIFS 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 in cell C12. The function will automatically update and display the new result.