Perform a calculation using SUM and AVERAGE functions

How to perform a calculation using SUM and AVERAGE functions in MS Excel:

Assuming you have a data set of exam scores in cells A1:A10:

1. Select cell B1 (where you want to display the total score)
2. Type: =SUM(A1:A10)
3. Press Enter

This will calculate the total score: ∑(A1:A10) = ?

1. Select cell B2 (where you want to display the average score)
2. Type: =AVERAGE(A1:A10)
3. Press Enter

This will calculate the average score: Average(A1:A10) = ?

Example:

| Exam Score | Total Score | Average Score |
| — | — | — |
| 80 | | |
| 70 | | |
| 90 | | |
| 85 | | |
| 75 | | |
| 95 | | |
| 80 | | |
| 70 | | |
| 85 | | |
| | =SUM(A1:A10) | =AVERAGE(A1:A10) |

Result:

| Exam Score | Total Score | Average Score |
| — | — | — |
| 80 | 805 | 80.5 |
| 70 | | |
| 90 | | |
| 85 | | |
| 75 | | |
| 95 | | |
| 80 | | |
| 70 | | |
| 85 | | |

In this example, the total score is 805, and the average score is 80.5

Share this:

Leave a Comment