How to Find Average in Microsoft Excel

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

1. Open the file you want to edit in Microsoft Excel.
2. Click on the cell where you want to calculate and display the average.
3. 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.
4. Press the Enter key to confirm and calculate the result.
5. Click and drag the bottom corner of the cell downward to automatically apply the AVERAGE formula to the remaining rows.