Excel SUM Practice Question: The bank statement lists deposits as positive and withdrawals as negative.…
The question
The bank statement lists deposits as positive and withdrawals as negative. Using SUM, find the closing balance (opening balance plus all entries) and put it in B9.
The data
| A | B | |
|---|---|---|
| 1 | Entry | Amount |
| 2 | Opening balance | 50000 |
| 3 | Salary | 42000 |
| 4 | Rent | -15000 |
| 5 | Groceries | -6200 |
| 6 | Electricity | -1850 |
| 7 | Refund | 1200 |
| 8 | Card bill | -9300 |
| 9 | Closing | ? |
The yellow cell is where your answer goes.
Show answer
Answer in B9: 60850
How it works
Explanation: Negative numbers are simply subtracted when you SUM them. So one SUM over the whole list gives the closing balance.
Syntax: =SUM(B2:B8)
50000 + 42000 - 15000 - 6200 - 1850 + 1200 - 9300 = 60850.
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…
- 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.
- 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