Quick summary
The AVERAGE function in Microsoft Excel lets you quickly calculate the mean of a selected range of cells using a simple formula. Select a target cell, enter =AVERAGE() with your data range, press Enter, and drag the formula down to apply it across multiple rows.
Steps
- Open the file you want to edit in Microsoft Excel.
- Click on the cell where you want to calculate and display the average.
- Type an equal sign, followed by AVERAGE(, then click on the cells containing the data you want to average — for example, =AVERAGE(F2,G2,H2,I2) — and close the parentheses to complete the formula.
- Press the Enter key to confirm and calculate the result.
- Click and drag the bottom corner of the cell downward to automatically apply the AVERAGE formula to the remaining rows.
