Opening the AVERAGEIFS Function dialog box
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.