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.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of SUMIF
0/4The same formula in the other shapes it takes at work.
- SUM with Multiple Values
Sum values from multiple non-adjacent cells or ranges.
CoreIntermediate - SUMIF: total one category
Add up only the rows that belong to the group you were asked about.
Intermediate - SUMIFS: total with two conditions
One region and one product at the same time.
Advanced - SUMIF with a comparison
Add up only the values above a line — the criterion can be a comparison, not just a match.
Intermediate
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 |
Functions used here
What this exercise teachesMay contain 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.