← The library
Excel concept
Criteria strings
COUNTIF-family criteria are text: ">10", "<>West", "app*". Comparisons against cells are built with &.
Very commonDifficulty 1314 · Proficient
The shape of it
- In practice
Write the operator in quotes and join the value: ">"&A1. Wildcards * and ? match text.
Related
Learn the moves here — or let Wauvel run them on your numbers.
$99/mo, everything included. Free for 14 days, no card.
One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.