← Back to level 2
Level 2Level 2
SUMIF
Adds values that meet a single condition.
Syntax
=SUMIF(range, criteria, [sum_range])Step-by-step explanation
- 1Choose the range that contains the condition you want to test.
- 2Define the criteria, such as a text match or comparison.
- 3Optionally choose a separate sum range.
Common mistakes
Misplacing the criteria argument
Using sum range of a different size
Forgetting quotation marks around text criteria
Example table
A quick scenario to connect the syntax to the result.
| Apples | 20 |
| Oranges | 15 |
Formula
=SUMIF(A1:A2,"Apples",B1:B2)
Result
20
Practice area
Sum only the Apple rows.
Match against the syntax block above.