Home > Topics > excel > How to use the table average formula

How to use the table average formula

Release: 2019-06-15 13:45:21
Original
52221 people have browsed it

How to use the table average formula

The formula for finding the average in Excel: "=AVERAGE()". Specific method: Select "Insert Function" in the "Formula" option in the menu bar, then select the average function AVERAGE in the pop-up dialog box, enter the data range of the average value, and then the average value can be calculated.

The specific method is as follows:

Method 1:

1. Open the data that needs to be averaged, as shown in the figure.

How to use the table average formula

#2. Move the cursor to the cell with the average result. Select "Insert Function" in the "Formula" option in the menu.

How to use the table average formula

#3. Select the function AVERAGE to find the average.

How to use the table average formula

#4. Click AVERAGE to enter the interface as shown in the figure, and enter the data range for the average value.

How to use the table average formula

5. Click OK to get the desired result.

How to use the table average formula

Method 2:

1. Enter "=" as shown in the picture.

How to use the table average formula

#2. Select AVERAGE and enter the unit range for which the average is required in the pop-up dialog box.

How to use the table average formula

3. The cell of the desired result will change to the interface as shown in the figure. Click OK to get the final result in method one.

How to use the table average formula

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to use the table average formula. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template