How to calculate the average in Excel

The following article guides you in detail how to calculate the average in Excel.

There are 2 ways to calculate an average:

- Calculate the average value according to the usual calculation formula.

- Calculate the average value using the Average function.

1. Calculate the average using the calculation formula

For example, there are transcripts that calculate the average of 3 subjects of the student:

How to calculate the average in Excel Picture 1

- In the cell to calculate, enter the formula: = (E6 + F6 + G6) / 3

How to calculate the average in Excel Picture 2

- Press Enter to get the results:

How to calculate the average in Excel Picture 3

Here the odd average has too many decimal places you need to reformat for easy viewing. Right-click the cell containing the average score -> select Format Cells .

How to calculate the average in Excel Picture 4

The dialog box appears to select the data type number, in the Decimal places section select the number of digits for the decimal part, for example, here choose 2 decimal places. Click OK to confirm your selection:

How to calculate the average in Excel Picture 5

- Finally copying the formula to the remaining values ​​results:

How to calculate the average in Excel Picture 6

2. Calculate the average value using the Average function

In the cell to calculate enter the formula: = Average (E6, F6, G6)

How to calculate the average in Excel Picture 7

In addition, with the Average function, you can enter parameters by selecting the data area to calculate the average value:

How to calculate the average in Excel Picture 8

Pressing Enter results:

How to calculate the average in Excel Picture 9

Copying the formula for the remaining values ​​results in:

How to calculate the average in Excel Picture 10

Above is a detailed guide on how to calculate an average in Excel. Good luck!