Excel SUM Practice Question: Monthly revenue is in B2:B7. Show the running (cumulative) total in D2:D7, so…
The question
Monthly revenue is in B2:B7. Show the running (cumulative) total in D2:D7, so D4 is Jan + Feb + Mar.
The data
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | Revenue | Running total | |
| 2 | Jan | 18500 | ? | |
| 3 | Feb | 21200 | ? | |
| 4 | Mar | 19800 | ? | |
| 5 | Apr | 24600 | ? | |
| 6 | May | 22350 | ? | |
| 7 | Jun | 26900 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- D2 = 18500
- D3 = 39700
- D4 = 59500
- D5 = 84100
- D6 = 106450
- D7 = 133350
How it works
Explanation: The first cell is locked with dollar signs and the second is not, so when you fill down, the range grows by one row each time.
Syntax: =SUM($B$2:B2)
Running totals: 18500, 39700, 59500, 84100, 106450, 133350.
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.
- 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.
All practice questions · Excel exercises · Interview prep · Cheat sheet