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.

Average a group of numbers

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? (2:14)

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

AVERAGEIF function

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

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

Weighted average

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. (2:26)

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

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

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!

×