Excel SUM Practice Question: Using SUM, find each student's total marks across the three subjects and put…
The question
Using SUM, find each student's total marks across the three subjects and put them in E2 and E3.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Student | Maths | Science | English | Total |
| 2 | Anil | 78 | 85 | 70 | ? |
| 3 | Bina | 92 | 88 | 81 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- E2 = 233
- E3 = 261
How it works
Explanation: SUM works across a row just as well as down a column. Select the three subject cells for each student.
Syntax: =SUM(B2:D2)
Anil: 78 + 85 + 70 = 233. Bina: 92 + 88 + 81 = 261.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →SUM syntax
=SUM(number1, [number2], ...)
Adds up all the numbers in a range — the most-used formula in Excel. Totaling four quarters of sales into an annual figure. Full SUM guide.
More SUM practice questions
- Using SUM, find the total units sold and put it in B6.
- The cashier skipped Wednesday, so that cell is empty. Using SUM, find the week's total…
- Two stores report weekly sales in separate columns. Using one SUM over both columns,…
- Build a running total of the daily sales in column C. Using SUM with a locked start…
- Using SUM, find what share of total sales Delhi has (as a decimal) and put it in C2.
- The bank statement lists deposits as positive and withdrawals as negative. Using SUM,…
- Using SUM, find net sales (total sales minus total returns) and put it in B7.
- Using SUM, find the final invoice total including 18% GST on the four items and put it…
All practice questions · Excel exercises · Interview prep · Cheat sheet