How To Find Mean In Excel?

Select an empty cell where you want the mean to appear

Type `=AVERAGE(range)`

Replace `range` with the cells you want to average, such as `A1:A10`

Press Enter

Use multiple ranges if needed, such as `=AVERAGE(A1:A10, C1:C10)`

To average non-adjacent cells, include each cell or range separated by commas

To ignore blanks and text, use the `AVERAGE` function as it does automatically

To calculate the mean of filtered data only, use `=SUBTOTAL(1, range)`

Suggested for You

Trending Today