Video: Average a group of numbers

Try it! Transcript



You may have used AutoSum to quickly add numbers in Excel. But did you know you can also use it to calculate other results, such as averages?

Use AutoSum to quickly find the average

AutoSum lets you find the average in a column or row of numbers where there are no blank cells.

1. Click a cell below the column or to the right of the row of the numbers for which you want to find the average.

2. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.

Want more?

Find the average of a group of numbers

AVERAGE function

AVERAGEIF function

You may have used AutoSum to quickly add numbers in Excel.

But did you know you can also use it to calculate other results, such as averages?

Click the cell to the right of a row or below a column. Then, on the HOME tab, click the AutoSum down arrow, click Average, verify the formula if what you want, and press Enter.

When I double-click inside the cell, I see it is a formula with the AVERAGE function.

The formula is AVERAGE, A2, colon, A5, which averages the cells from A2 through A5.

When averaging a few cells, the AVERAGE function saves your time. With larger ranges of cells, it's essential.

If I try to use the AutoSum, Average option here, it only uses cell C5, not the entire column.

Why? Because C4 is blank.

If C4 contained a number, C2 through C5 would be an adjacent range of cells that AutoSum would recognize.

To average values in cells and ranges of cells that aren't adjacent, type an equals sign (a formula always starts with an equals sign), AVERAGE, open parenthesis, hold down the Ctrl key, click the desired cells and ranges of cells, and press Enter.

The formula uses the AVERAGE function to average the cells containing numbers and ignores the empty cells or those containing text.

For more information about the AVERAGE function, see the course summary at the end of the course.

Up next, AVERAGEIF.