Exercises / Conditional counting and sums · 2 of 11
Count orders above a threshold
Criteria can compare: ">=500" counts values of 500 or more. To compare with a cell, join the operator to it with &: ">="&F1. Inside the quotes, F1 would be just the letters F and 1.
Your taskIn F2, use COUNTIF to count the orders in B2:B11 that are at least the threshold in F1.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Order | Amount | Threshold | $500.00 | ||
| 2 | #2201 | $820.00 | Orders ≥ threshold | |||
| 3 | #2202 | $145.00 | ||||
| 4 | #2203 | $500.00 | ||||
| 5 | #2204 | $1,290.00 | ||||
| 6 | #2205 | $310.00 | ||||
| 7 | #2206 | $499.00 | ||||
| 8 | #2207 | $675.00 | ||||
| 9 | #2208 | $250.00 | ||||
| 10 | #2209 | $2,040.00 | ||||
| 11 | #2210 | $88.00 |