Home  >  Article  >  Topics  >  How to calculate total score and average score in excel

How to calculate total score and average score in excel

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-24 16:42:3163215browse

Calculation method: First open the excel table that needs to be operated, select the total score cell; then enter "=sum (specified area)" in the cell to calculate the total score of the area; then select average Divide cells into cells and enter "=AVERAGE (specified area)" in the cell to find the average score of the area.

How to calculate total score and average score in excel

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Double-click to open the excel table where the total score and average score need to be calculated. After opening the table, enter an equal sign in the total score cell.

How to calculate total score and average score in excel

Then enter SUM and double-click the SUM function in the options below.

How to calculate total score and average score in excel

Next select the cells for which the total score needs to be calculated, as shown in the figure.

How to calculate total score and average score in excel

After selection, complete the closing bracket and click once to enter the symbol.

How to calculate total score and average score in excel

In this way, you can see that the calculated total score is obtained in the cell where the function was just entered, and then place the mouse in the lower right corner of the cell until it changes to plus After number, hold down the left mouse button and drag down to the last cell, then release.

How to calculate total score and average score in excel

Next, enter the AVERAGE function in the average cell.

How to calculate total score and average score in excel

Then select the cells for which the average score needs to be calculated.

How to calculate total score and average score in excel

Then, enter a right bracket and click the input icon to confirm.

How to calculate total score and average score in excel

The process of calculating the average score has been completed.

Related learning recommendations: excel tutorial

###

The above is the detailed content of How to calculate total score and average score in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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