Average a group of numbers

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.

Applies to:
File Size:

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.