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.
A brief reminder of the key points in this course.
More courses available at Microsoft Office Training.