Excel SUM Practice Question: Two stores report weekly sales in separate columns. Using one SUM over both…
The question
Two stores report weekly sales in separate columns. Using one SUM over both columns, find the combined sales for all four weeks and put it in B6.
The data
| A | B | C | |
|---|---|---|---|
| 1 | Week | Store A | Store B |
| 2 | Week 1 | 24500 | 19800 |
| 3 | Week 2 | 26100 | 21400 |
| 4 | Week 3 | 23800 | 20250 |
| 5 | Week 4 | 28900 | 22600 |
| 6 | Combined | ? |
The yellow cell is where your answer goes.
Show answer
Answer in B6: 187350
How it works
Explanation: SUM accepts a two-dimensional range, so one formula can total several columns at once.
Syntax: =SUM(B2:C5)
Store A: 24500 + 26100 + 23800 + 28900 = 103300. Store B: 19800 + 21400 + 20250 + 22600 = 84050. Together: 187350.
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…
- 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