Opening the AVERAGEIF Function dialog box
Although it is possible to just type the AVERAGE IF 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, click on the image above.
- Click on cell E12 to make it the active cell. This is where we will enter the AVERAGE IF 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 AVERAGE IF in the list to bring up the AVERAGE IF function's dialog box.
The data that we enter into the three blank rows in the dialog box will form the arguments of the AVERAGE IF function.
These arguments tell the function what condition we are testing for and what range of data to average when the condition is met.
