Basic Functions
Intermediate
SUM with Multiple Values
Sum values from multiple non-adjacent cells or ranges.
Task:
You need to calculate the total revenue for specific quarters to analyze seasonal performance. Calculate the combined total revenue for Q1 and Q3 in cell B7 by summing the revenue from these non-adjacent quarters.
Learning Objectives:
- Learn to sum non-adjacent cells
- Understand multiple argument syntax for SUM or direct addition
- Practice selective data aggregation
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Quarter | Revenue |
| 2 | Q1 | 25000 |
| 3 | Q2 | 30000 |
| 4 | Q3 | 28000 |
| 5 | Q4 | 32000 |
| 6 | ||
| 7 | Q1 + Q3 Total |
What this exercise teaches (contains the answer)
In Excel, to sum multiple non-adjacent values, you can either add them individually or use the SUM function with each value as a separate argument. This is useful when you need to total specific entries, like selected quarters or categories, rather than a continuous range.