Exercises / Conditional counting and sums · 4 of 11
Total with two conditions
SUMIFS(sum_range, range1, criteria1, range2, criteria2, …) adds the rows that meet every condition. Unlike SUMIF, the range to add comes first.
Your taskIn H3, use SUMIFS to add up the amounts in E2:E13 for the region in H1 and the product in H2.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Date | Region | Rep | Product | Amount | Region | North | |
| 2 | 1 Jan 2026 | North | Ana | Laptop | $1,450.00 | Product | Monitor | |
| 3 | 2 Jan 2026 | South | Ben | Monitor | $320.00 | Total | ||
| 4 | 2 Jan 2026 | North | Ana | Monitor | $290.00 | |||
| 5 | 4 Jan 2026 | East | Cara | Laptop | $1,380.00 | |||
| 6 | 5 Jan 2026 | North | Dino | Monitor | $310.00 | |||
| 7 | 6 Jan 2026 | South | Ben | Laptop | $1,520.00 | |||
| 8 | 7 Jan 2026 | North | Ana | Dock | $180.00 | |||
| 9 | 8 Jan 2026 | East | Cara | Monitor | $305.00 | |||
| 10 | 9 Jan 2026 | North | Dino | Laptop | $1,490.00 | |||
| 11 | 11 Jan 2026 | South | Ben | Monitor | $335.00 | |||
| 12 | 12 Jan 2026 | North | Ana | Monitor | $299.00 | |||
| 13 | 13 Jan 2026 | East | Cara | Dock | $175.00 |