Calculating Averages in Excel

Buzz

Ngày cập nhật gần nhất: 15/5/2026

Content

1. Calculate the average with a formula

2. Using the Average function to calculate the mean

This guide simplifies average calculations in Excel.

Two methods for average calculation:

- Use the standard formula for average calculation.

- Calculate the average using the Average function.

1. Calculate the average with a formula

Example: Calculating the average score of three subjects for a student:

- Enter the formula in the desired cell: =(E6+F6+G6)/3

- Press Enter to display the result.

If the average value has too many decimal places, format it for clarity. Right-click the cell containing the average -> choose Format Cells…

A dialog box appears. Select the number data type and in the Decimal places section, choose the number of decimal places, for instance, select 2 decimal places. Click OK to confirm.

- Finally, replicate the formula across other values to obtain the results.

2. Using the Average function to calculate the mean

Enter the formula in the desired cell: =Average(E6,F6,G6)

With the Average function, parameters can be entered by selecting the data range for average calculation.

Press Enter to obtain the result.

Copy the formula for the remaining values to get the results:

Here is a detailed guide on how to calculate the mean in Excel. Wishing you success!

Frequently Asked Questions

What are the two main methods for calculating averages in Excel?

The two main methods for calculating averages in Excel are using a standard formula and the built-in Average function. Both methods effectively compute the mean, but they cater to different user preferences.

How can I calculate the average score of multiple subjects in Excel?

To calculate the average score of multiple subjects in Excel, you can enter the formula =(E6+F6+G6)/3 in a desired cell, then press Enter. Alternatively, use the Average function with =Average(E6,F6,G6) for a similar result.

How do I format average results to display fewer decimal places?

To format average results in Excel for fewer decimal places, right-click the cell containing the average, select Format Cells, and choose the number data type. In the Decimal places section, select your desired number, such as 2, and click OK.

Can I copy formulas to calculate averages for multiple values in Excel?

Yes, you can copy formulas in Excel to calculate averages for multiple values. After entering the formula in one cell, drag the fill handle down or across to apply the same calculation to adjacent cells quickly.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]