Average a group of numbers

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×