How To Find The 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 `)` and press Enter

Example: `=AVERAGE(A1:A10)`

To average non-adjacent cells, use commas between cell references

Example: `=AVERAGE(A1,A3,A5)`

To average a row, select the row range

Example: `=AVERAGE(1:1)`

To average a column, select the column range

Example: `=AVERAGE(A:A)`

Use the AutoSum drop-down and choose Average

Check that the cells contain numbers, not text

Use `=AVERAGEIF()` to average cells that meet a condition

Use `=AVERAGEIFS()` to average cells that meet multiple conditions

Suggested for You

Trending Today