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)
The AVERAGEIF function returns the average of cells in a range that meet criteria you provide. (3:14)
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)
A brief reminder of the key points in this course summary.
More courses available at Microsoft Office Training.