Opening the AVERAGEIF Function dialog box
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.
These arguments tell the function what condition we are testing for and what range of data to average when the condition is met.