How To Do Average In Excel?

Select the cell where you want the average to appear

Type `=AVERAGE(`

Select the range of cells you want to average

Type `)`

Press Enter

Example: `=AVERAGE(A1:A10)`

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

Suggested for You

Trending Today