Average

Updated: 10/02/2017 by Computer Hope
average

Alternatively referred to as the arithmetic mean, an average is the sum of a series of numbers, divided by the total amount of numbers. For example, suppose we have the following series of numbers: 1, 2, 3, 4, 1, 2, and 3. The sum of these numbers is 16, 16 divided by 7 is 2.28. Therefore, 2.28 is the average of these numbers.

Microsoft Excel

In Microsoft Excel and other spreadsheets, you can determine the average of multiple cells by using the average formula function. For example, the below formula would determine the average of the values in cells A1 through F1 and could be placed in cell G1 or any other cell.

=AVERAGE(A1:F1)
Tip

You can also use the min function to get the minimum value and the max function to get the maximum.

Tip

If you had a spreadsheet with multiple averages and wanted to get the average of all the averages, use the same formula on the cells containing the averages. For example, if you had 20 averages in the D column, you could use the formula =AVERAGE(D1:D20) in the D21 cell.

Avg, Median, Mode, Number, Spreadsheet terms