SUMIF with a number condition
PremiumIn D2, use SUMIF to total the amounts greater than 100.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Amount | ||||
| 2 | 1001 | 40 | ||||
| 3 | 1002 | 110 | ||||
| 4 | 1003 | 95 | ||||
| 5 | 1004 | 20 | ||||
| 6 | 1005 | 300 | ||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock SUMIF and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:SUMIFSCOUNTIFS
Need help?
Why this works
When the condition is about the numbers themselves, SUMIF needs only two arguments: it checks B2:B6 and adds up the same cells.
Common mistake: Writing the condition without quotes, like >100. A condition with an operator is text: ">100".
The answer
- D2
=SUMIF(1B2:B6,2">100")
In plain words: Add up the amounts 1in B2:B6 that are 2greater than 100.