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.
It comes up in this mock test: Excel test for job interviews
Your first month for $9.50 $19
50% off your first month when you join today.
Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.
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.