How to calculate total score and average score in excel

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.

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.

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

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

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

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.

Next, enter the AVERAGE function in the average cell.

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

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!