How To Calculate Average In Excel?

Select the cell where you want the average to appear

Type `=AVERAGE(range)`

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

Press Enter

Use `=AVERAGE(A1:A10)` for a single continuous range

Use `=AVERAGE(A1,A3,A5)` for non-adjacent cells

Use `=AVERAGEIF(range, criteria, [average_range])` for conditional averages

Use `=AVERAGEIFS(average_range, criteria_range1, criteria1, …)` for multiple conditions

Use the AutoSum dropdown and choose Average

Check that the cells contain numeric values and not text

Ignore blank cells automatically included by the AVERAGE function

Suggested for You

Trending Today