← Back to level 2
Level 2Next
SUMIFS
A medium conditional total formula for multiple rules, useful when one filter is not enough to define the result.
Syntax
=SUMIFS(...)Step-by-step explanation
- 1Choose the range that will be checked against your condition.
- 2Add the criteria so Excel knows which rows should count or sum.
- 3Review the result to make sure only matching rows were included.
Common mistakes
Using ranges that are not the same size
Mixing up the order of criteria pairs
Leaving out one of the conditions you intended to apply
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=SUMIFS(A1:B2)
Result
68
Worked example
- 1Find the category column and the amount column in the sample table.
- 2Apply =SUMIFS(A1:B2) so only the matching category contributes to the total.
- 3Excel should return 68 for the chosen category.
Practice area
Use SUMIFS when the total should only include rows that meet several business conditions.
Match against the syntax block above.
Real-life use cases
Department totalsMulti-rule revenue reportsFiltered expense summaries
Related formulas