Average may refer to any of the following:

  1. When referring an Adobe Photoshop, see our Photoshop Average filter.

  2. Alternatively called the arithmetic mean, an average is the sum of several 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 (ammount of numbers) is 2.28. Therefore, 2.28 is the average of these numbers.

How to find the average in Microsoft Excel

In Microsoft Excel and other spreadsheets, you can determine the average of multiple cells with the appropriate formula. The formula in the example below determines the average of the values in cells A1 through F1 in the first column.

=AVERAGE(A1:F1)

To determine the average of cells in a row, you’d use the same row but change the cells to cells in a row. For example, the following formula finds the average value in cells A1 through A20 when placed in cell A21.

=AVERAGE(A1:A20)

  • Getting #DIV/0! in Microsoft Excel spreadsheet.

Avg, Median, Mode, Number, Spreadsheet terms

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

With a spreadsheet with multiple averages, you can get the average of all averages with 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.

  • Help, examples, and information on Excel formulas.
  • Microsoft Excel help and support.