Excel SUM Practice Question: The cashier skipped Wednesday, so that cell is empty. Using SUM, find the…
The question
The cashier skipped Wednesday, so that cell is empty. Using SUM, find the week's total collection and put it in B8.
The data
| A | B | |
|---|---|---|
| 1 | Day | Collection |
| 2 | Mon | 4200 |
| 3 | Tue | 3900 |
| 4 | Wed | |
| 5 | Thu | 4600 |
| 6 | Fri | 5100 |
| 7 | Sat | 6800 |
| 8 | Total | ? |
The yellow cell is where your answer goes.
Show answer
Answer in B8: 24600
How it works
Explanation: SUM ignores blank cells, so a missing entry does not cause an error or change the total.
Syntax: =SUM(B2:B7)
4200 + 3900 + 4600 + 5100 + 6800 = 24600. The blank cell adds nothing.
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.
- Using SUM, find each student's total marks across the three subjects and put them in E2…
- 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