# Average a group of numbers

When you need to find an average, you can click a button, or use a function in a formula. The AutoSum button lets you find the average in a column or row of numbers where there are no blank cells. Use the AVERAGE or the AVERAGEIF functions to find the average of numbers that aren’t in a contiguous row or column. And use the SUMPRODUCT and the SUM functions to find a weighted average, which depends on the weight that’s applied to the values.

## Inside this course:

**Average a group of numbers**** ****(****2:14****)**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?

**AVERAGEIF function**** ****(****3:14****)**The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.

**Weighted average**** ****(****2:26****)**Usually when you calculate an average, all of the numbers are given equal significance; the numbers are added together and then divided by the number of numbers. With a weighted average, one or more numbers is given a greater significance, or weight.

**Course summary**** **A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.