How to calculate Sum and Average of numbers using formulas in MS ... - Free Printable

The image shows an Excel spreadsheet with student names and their marks in various subjects (Maths, English, Biology, Physics, Chemistry). The total marks for each student are already calculated in column H. The task is to calculate the average of the total marks using the `AVERAGE` function.

---

✔ Step-by-step Solution:

1. Understand the Goal:
- We want to find the average of the total marks listed in column H (from H2 to H13).
- The formula `=AVERAGE()` is already started in cell H15.

2. Select the Range:
- The total marks are from H2 to H13.
- So, we need to include all these values in the AVERAGE function.

3. Enter the Formula:
- In cell H15, complete the formula as:
```
=AVERAGE(H2:H13)
```

4. Explanation:
- `H2:H13` refers to the range of cells containing the total marks for all 12 students.
- The `AVERAGE` function will sum all the values in this range and divide by the count of numbers (12 in this case).

---

🔢 Example Calculation:

Let’s add up the total marks manually to verify:

```
371 + 419 + 396 + 293 + 327 + 279 + 372 + 338 + 374 + 263 + 242 = ?
```

Sum =
371 + 419 = 790
790 + 396 = 1186
1186 + 293 = 1479
1479 + 327 = 1806
1806 + 279 = 2085
2085 + 372 = 2457
2457 + 338 = 2795
2795 + 374 = 3169
3169 + 263 = 3432
3432 + 242 = 3674

Now divide by 12 (number of students):

> 3674 ÷ 12 ≈ 306.17

So, the average total mark is approximately 306.17.

---

✔ Final Answer:

In cell H15, enter:

```excel
=AVERAGE(H2:H13)
```

This will give you the average of total marks, which is 306.17.

---

✔ Tip: You can also use the AutoSum feature:
- Click on H15 → Go to "Formulas" tab → Click "More Functions" → "Statistical" → "AVERAGE".
- Then select H2:H13.

Let me know if you'd like to calculate subject-wise averages too!