How to use AVERAGEIF function in your workbook:
- Open your Microsoft Excel worksheet and select the range of cells that contain the data.
- Click the cell where you want the AVERAGEIF function to appear.
- Enter the function in the cell. The syntax for function is: =AVERAGEIF(range, criteria, [average_range]).
- In the range argument, enter the range of cells that contain the data.
- In the criteria argument, enter the criteria for which to average the data. This can be a value, formula, or text. In the [average_range] argument, enter the range of cells that contain the data to average. This can be left blank if the range argument is the same as the average_range argument.
- Press Enter to calculate the result.
- The function will return the average of cells in the range that match the criteria.
