Opening the AVERAGEIFS Function dialog box
Although it is possible to just type the AVERAGEIFS function into a cell, many people find it easier to use the function's dialog box to add the function to a worksheet.
Tutorial Steps
For help with these instructions, see the image above.
- Click on cell E12 to make it the active cell. This is where we will enter the AVERAGEIFS function.
- Click on the Formulas tab of the ribbon.
- Choose More Functions > Statistical from the ribbon to open the function drop down list.
- Click on AVERAGEIFS in the list to bring up the AVERAGEIFS dialog box.
The data that we enter into the blank lines in the dialog box will form the arguments of the AVERAGEIFS function.
These arguments tell the function what conditions we are testing for and what range of data to average when those conditions are met.
