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.
It comes up in this mock test: Excel assessment (Indeed format)
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
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.