COUNTIF with a number condition
PremiumIn D2, use COUNTIF to count the invoices in B2:B8 of 1500 or more.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Amount | 1500 or more | |||
| 2 | I-01 | 850 | ||||
| 3 | I-02 | 1200 | ||||
| 4 | I-03 | 1500 | ||||
| 5 | I-04 | 640 | ||||
| 6 | I-05 | 2300 | ||||
| 7 | I-06 | 1499 | ||||
| 8 | I-07 | 1800 | ||||
| 9 |
Premium lesson
Unlock COUNTIF 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:SUMIFSUMIFS
Need help?
Why this works
A number condition is written as text: the operator and the number inside quotes, ">=1500". The operators are =, <>, >, >=, < and <=.
Common mistake: Leaving out the quotes, like >=1500. The operator and the number go inside the quotes together: ">=1500".
The answer
- D2
=COUNTIF(1B2:B8,2">=1500")
In plain words: Count the amounts 1in B2:B8 that are 21500 or more.