Excel SUM Practice Question: Months are listed in rows 2 to 7. Using SUM with INDEX, add the sales from…
The question
Months are listed in rows 2 to 7. Using SUM with INDEX, add the sales from January up to the month number typed in F2 and put the result in F3.
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Month | Sales | Up to month # | |||
| 2 | Jan | 12000 | 4 | |||
| 3 | Feb | 15500 | Total | ? | ||
| 4 | Mar | 14200 | ||||
| 5 | Apr | 16800 | ||||
| 6 | May | 18100 | ||||
| 7 | Jun | 19400 |
The yellow cell is where your answer goes.
Show answer
Answer in F3: 58500
How it works
Explanation: INDEX can return a cell reference, so B2:INDEX(B2:B7,F2) builds a range that ends at the month you choose. Change F2 and the total updates.
Syntax: =SUM(B2:INDEX(B2:B7,F2))
F2 is 4, so the range is B2:B5: 12000 + 15500 + 14200 + 16800 = 58500.
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
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