How to count cells greater than a value
✓ Verified in LibreOffice 25.8.7.3Count how many cells pass a numeric threshold, like scores over 80 or orders over $100.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =COUNTIF(A2:A6,">100") | The comparison goes in quotes. Use ">=" for at-least, "<" for below. |
| Google Sheets | =COUNTIF(A2:A6,">100") | Identical. |
| LibreOffice Calc | =COUNTIF(A2:A6,">100") | Identical. |
How it works
COUNTIF's criterion is a text string, so the comparison operator and number go together in quotes: ">100". In the sample, only 150 and 200 exceed 100, so the count is 2 — note 100 itself is excluded; use ">=100" to include it. To reference a cell as the threshold, concatenate: =COUNTIF(A2:A6,">"&C1).
Verified, not just documented
We ran =COUNTIF(A2:A6,">100") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 2 — exactly the expected result. Every formula here is confirmed by actually executing it.